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 starting postgresql in vps

Discussion in 'Database Discussions' started by camilo0925, Jul 21, 2013.

  1. camilo0925

    camilo0925 Registered

    Joined:
    Oct 23, 2012
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    hi.

    ihave this error when start the postgres service:

    service postgresql restart
    Stopping postgresql service: [ OK ]
    Starting postgresql service: /etc/init.d/postgresql: line 114: echo: write error: Operation not permitted
    [ OK ]

    the service apparently starts, but continues showing that error, and in the phppgadmin shows login failed.. the files pg_hba.conf and postgresql.conf i edited for made the remote connection, and the firewall is down... but it dont connect nor by telnet nor by pgadmin to the port 5432

    psql --version
    psql (PostgreSQL) 8.4.13
    contains support for command-line editing

    any idea?

    Many thanks for your help
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Please check the following log file when attempting to start PostgreSQL:

    Code:
    /var/lib/pgsql/pgstartup.log
    Do you notice any specific output?

    Thank you.
     
  3. camilo0925

    camilo0925 Registered

    Joined:
    Oct 23, 2012
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    hi..

    thanks for the info... i run that and show me this:

    root@vps [~]# tail -f /var/lib/pgsql/pgstartup.log
    copying template1 to template0 ... ok
    copying template1 to postgres ... ok

    Success. You can now start the database server using:

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

    LOG: could not open temporary-files directory "base/pgsql_tmp": Permission denied
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Please check the permissions/ownership value on the pgsql_tmp directory and the base directory itself. EX:

    Code:
    stat /var/lib/pgsql/data/base/pgsql_tmp
    stat /var/lib/pgsql/data/base
    Are the directories owned by the "postgres" user with 0700 permissions?

    Thank you.
     
Loading...

Share This Page