On Tue, Mar 4, 2008 at 4:51 PM, <[EMAIL PROTECTED]> wrote: > > > thanks for replying > > when i run this command i found the error as > > pg_ctl reload -l logfile -D /var/lib/pgsql/data > could not change directory to "/root" > pg_ctl: PID file "/var/lib/pgsql/data/postmaster.pid" does not exist > Is server running? > > plz could u help me for this thank in advance >
Please DO NOT exclude the list from the conversation. Adding GENERAL again. I am not able to understand the following line in your error log: <> could not change directory to "/root" </> maybe someone else can help here. Are you sure you have a running postgres instance on this box? The 'reload' command can be executed only for a running Postgres instance. If postgres is running (ps or top commands can help determine that), then figure out which directory is that instance using as it's DATA directory. If postgres is not running, then substitute the 'reload' in your command with 'start'. If you are still unable to solve the problem, then please send us the output of following commands: (assuming you are on a nixen (linux/Unix)) ps aux | grep postmaster ps aux | grep postgres which pg_ctl Best regards -- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com 17° 29' 34.37"N, 78° 30' 59.76"E - Hyderabad 18° 32' 57.25"N, 73° 56' 25.42"E - Pune * 37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco http://gurjeet.frihost.net Mail sent from my BlackLaptop device