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!

Error configuring PostgreSQL Error: PostgreSQL is not running.

Discussion in 'Database Discussion' 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:
    604
    Likes Received:
    43
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 SysSachin, Nov 24, 2016
    Last edited by a moderator: Nov 25, 2016
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

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

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

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice