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@gallo.ucsf.edu
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Mon 8/13/2007 3:37 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] postmaster.pid file
"Tena Sakai" <tsakai@gallo.ucsf.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