Error configuring PostgreSQL Error: PostgreSQL is not running.

andreiev

Registered
Nov 24, 2016
1
0
1
Terra
cPanel Access Level
Root Administrator
But it is running, and rather fine. I can configure Postgresql from cli, so this is not a big issue for me, but I would like to get it fixed somehow. this is the content of /var/lib/pgsql/pgstartup.log :

Code:
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/pgsql/9.6/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

Success. You can now start the database server using:

    /usr/pgsql-9.6/bin/pg_ctl -D /var/lib/pgsql/9.6/data -l logfile start

< 2016-11-24 07:55:49.089 MST > LOG:  could not create IPv6 socket: Address family not supported by protocol
< 2016-11-24 07:55:49.101 MST > LOG:  redirecting log output to logging collector process
< 2016-11-24 07:55:49.101 MST > HINT:  Future log output will appear in directory "pg_log".
< 2016-11-24 07:57:23.096 MST > LOG:  could not create IPv6 socket: Address family not supported by protocol
< 2016-11-24 07:57:23.159 MST > LOG:  redirecting log output to logging collector process
< 2016-11-24 07:57:23.159 MST > HINT:  Future log output will appear in directory "pg_log".
Any ideas are welcomed. Thank you!
 

SysSachin

Well-Known Member
Aug 23, 2015
604
48
28
India
cPanel Access Level
Root Administrator
Twitter
Is IPV6 enable on your server ?

Please try to disables it and check following post.

postgresql.org/message-id/20140204.133837.210606869.horiguchi.kyotaro%40lab.ntt.co.jp
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
Hello,

Could you verify if you installed PostgreSQL via the "/scripts/installpostgres" command or if this is a manual installation?

Thank you.