Re: postmaster.pid file

Thank you, Tom.

As I typed:
~/bin/pg_ctl -D ~/bin reload

I thought I had typed:
~/bin/pg_ctl -D ~/data reload

(Had I not copied-and-pasted the actual command,
I would have given you the correct line, which
would have been really bad!) I was blind!

I got the extra file in ~/bin directory removed.

Regards,

Tena
tsakai(at)gallo(dot)ucsf(dot)edu

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Mon 8/13/2007 3:37 PM
To: Tena Sakai
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] postmaster.pid file

"Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu> writes:
> When I issued, on a linux machine, the following
> command as user postgres:
> ~/bin/pg_ctl -D ~/bin reload
> It wasn't happy.

As well it shouldn't be. -D is supposed to specify the data directory,
not the place where the executables are.

> Upon checking, I discovered that the file postmaster.pid was
> in data directory and as I copied it into ~/bin directory (and
> changed the ownership and permission appropriately),

That was a bad idea; you'll have to delete it from there manually.

regards, tom lane