Failed to start PostgreSQL database server

Support Software & Applications
,
1

i have problem with postgresql after upgrade on boot screen said: Failed to start PostgreSQL database server.
i try many way, i cant figure out whats going on, please guide me.

systemctl status postgresql.service
● postgresql.service - PostgreSQL database server
     Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: disabled)
     Active: failed (Result: exit-code) since Mon 2021-06-14 19:38:36 +0430; 3min 31s ago
    Process: 42576 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGROOT}/data (code=exited, status=1/FAILURE)

Jun 14 19:38:36 korosh-pc systemd[1]: Starting PostgreSQL database server...
Jun 14 19:38:36 korosh-pc postgres[42576]: "/var/lib/postgres/data" is missing or empty. Use a command like
Jun 14 19:38:36 korosh-pc postgres[42576]:   su - postgres -c "initdb --locale en_US.UTF-8 -D '/var/lib/postgres/data'"
Jun 14 19:38:36 korosh-pc postgres[42576]: with relevant options, to initialize the database cluster.
Jun 14 19:38:36 korosh-pc systemd[1]: postgresql.service: Control process exited, code=exited, status=1/FAILURE
Jun 14 19:38:36 korosh-pc systemd[1]: postgresql.service: Failed with result 'exit-code'.
Jun 14 19:38:36 korosh-pc systemd[1]: Failed to start PostgreSQL database server.
2

“/var/lib/postgres/data” not exists now ? and exists before update today postgresql package ???
or is a new install ? if new, log message is clear

3

i try remove psql in package manager and reinstall it again and use this command:

sudo rm -rf /var/lib/postgresql/
sudo rm -rf /var/log/postgresql/
sudo rm -rf /etc/postgresql/
4

and now when i run psql see this:

psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket “/run/postgresql/.s.PGSQL.5432”?

5 
journalctl -xeu postgresql

░░ The job identifier is 130 and the job result is failed.
Jun 14 19:38:36 korosh-pc systemd[1]: Starting PostgreSQL database server...
░░ Subject: A start job for unit postgresql.service has begun execution
░░ Defined-By: systemd

░░  
░░ A start job for unit postgresql.service has begun execution.
░░  
░░ The job identifier is 1942.
Jun 14 19:38:36 korosh-pc postgres[42576]: "/var/lib/postgres/data" is missing or empty. Use a command like
Jun 14 19:38:36 korosh-pc postgres[42576]:   su - postgres -c "initdb --locale en_US.UTF-8 -D '/var/lib/postgres/data'"
Jun 14 19:38:36 korosh-pc postgres[42576]: with relevant options, to initialize the database cluster.
Jun 14 19:38:36 korosh-pc systemd[1]: postgresql.service: Control process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd

░░  
░░ An ExecStartPre= process belonging to unit postgresql.service has exited.
░░  
░░ The process' exit code is 'exited' and its exit status is 1.
Jun 14 19:38:36 korosh-pc systemd[1]: postgresql.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd

░░  
░░ The unit postgresql.service has entered the 'failed' state with result 'exit-code'.
Jun 14 19:38:36 korosh-pc systemd[1]: Failed to start PostgreSQL database server.
░░ Subject: A start job for unit postgresql.service has failed
░░ Defined-By: systemd

░░  
░░ A start job for unit postgresql.service has finished with a failure.
░░  
░░ The job identifier is 1942 and the job result is failed.
6

why not read your logs paste here ?

“/var/lib/postgres/data” is missing or empty. Use a command like
su - postgres -c “initdb --locale en_US.UTF-8 -D ‘/var/lib/postgres/data’”

read wiki how to install

7

su - postgres -c “initdb --locale en_US.UTF-8 -D ‘/var/lib/postgres/data’”
su: unrecognized option ‘–locale’

su - postgres -c “initdb en_US.UTF-8 -D ‘/var/lib/postgres/data’”
su: invalid option – ‘D’

su - postgres -c “initdb en_US.UTF-8 ‘/var/lib/postgres/data’”
en_US.UTF-8: line 1: “initdb: command not found