Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Error configuring PostgreSQL Error: PostgreSQL is not running.

Discussion in 'Database Discussions' started by andreiev, Nov 24, 2016.

Tags:
  1. andreiev

    andreiev Registered

    Joined:
    Nov 24, 2016
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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!
     
  2. SysSachin

    SysSachin Well-Known Member

    Joined:
    Aug 23, 2015
    Messages:
    568
    Likes Received:
    40
    Trophy Points:
    28
    Location:
    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
     
    #2 SysSachin, Nov 24, 2016
    Last edited by a moderator: Nov 25, 2016
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

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

    Thank you.
     
Loading...

Share This Page