camilo0925

Registered
Oct 23, 2012
4
0
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
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,911
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
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.
 

camilo0925

Registered
Oct 23, 2012
4
0
1
cPanel Access Level
Website Owner
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.
hi..

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

[email protected] [~]# 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

Technical Support Community Manager
Staff member
Apr 11, 2011
47,911
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
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.