Re: pg_ctl problem

On Tue, Mar 4, 2008 at 4:51 PM, <madhu(dot)harchandani(at)wipro(dot)com> 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
--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ 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