error starting postgresql in vps

[camilo0925]

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

 

[cPanelMichael]

Hello

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

/var/lib/pgsql/pgstartup.log

Do you notice any specific output?

Thank you.

 

[camilo0925]

Hello

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

/var/lib/pgsql/pgstartup.log

Do you notice any specific output?

Thank you.

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

 

[cPanelMichael]

Please check the permissions/ownership value on the pgsql_tmp directory and the base directory itself. EX:

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.