LinuxQuestions.org - starting postgresql

- Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)

- - starting postgresql (https://www.linuxquestions.org/questions/linux-newbie-8/starting-postgresql-4175645186/)

starting postgresql

This is what I did:

Code:

systemctl status postgresql

● postgresql.service - PostgreSQL database server

  Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; vendor preset: disa>

  Active: failed (Result: exit-code) since Sat 2018-12-29 13:32:02 EST; 3h 59min ago



Dec 29 13:32:02 linux-s6kv systemd[1]: Starting PostgreSQL database server...

Dec 29 13:32:02 linux-s6kv postgresql-script[1646]: postgres: could not access the server co>

Dec 29 13:32:02 linux-s6kv postgresql-script[1646]: pg_ctl: could not start server

Dec 29 13:32:02 linux-s6kv postgresql-script[1646]: Examine the log output.

Dec 29 13:32:02 linux-s6kv systemd[1]: postgresql.service: Control process exited, code=exit>

Dec 29 13:32:02 linux-s6kv systemd[1]: postgresql.service: Failed with result 'exit-code'.

Dec 29 13:32:02 linux-s6kv systemd[1]: Failed to start PostgreSQL database server.

Code:

systemctl enable postgresql

Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/sys

temd/system/postgresql.service.

Code:

systemctl start postgresql

Job for postgresql.service failed because the control process exited with error code.

See "systemctl status postgresql.service" and "journalctl -xe" for details.

Any ideas?

Quote:

Originally Posted by ultra99 (Post 5942627)

This is what I did:

Code:

systemctl status postgresql

● postgresql.service - PostgreSQL database server

  Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; vendor preset: disa>

  Active: failed (Result: exit-code) since Sat 2018-12-29 13:32:02 EST; 3h 59min ago



Dec 29 13:32:02 linux-s6kv systemd[1]: Starting PostgreSQL database server...

Dec 29 13:32:02 linux-s6kv postgresql-script[1646]: postgres: could not access the server co>

It fails because it can’t access some server. Try displaying the full lines; I think the option for that is -l. Also use journalctl to display the full postgresql log.