"Tena Sakai" <tsakai@xxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend