Hi Tom,
An excellent suggestion and I've just done it.
Many thanks.
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 8/13/2007 4:21 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] postmaster.pid file
"
Tena Sakai wrote:
> ~/bin/pg_ctl -D ~/bin reload
It's quite unlikely that your data directory is "~/bin".
> As I looked at the pid file, there were three lines. The
> first line seemed like the pid of the server process. The
> second line indicates where the database cluster resides.
"Tena Sakai" <[EMAIL PROTECTED]> writes:
> As I typed:
> ~/bin/pg_ctl -D ~/bin reload
> I thought I had typed:
> ~/bin/pg_ctl -D ~/data reload
I recommend setting up PGDATA as an environment variable, so you never
have to type it at all ...
regards, tom lane
-
directory removed.
Regards,
Tena
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 8/13/2007 3:37 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] postmaster.pid file
"Tena Sakai" <[EMAIL PROTECTED]> writes:
>
"Tena Sakai" <[EMAIL PROTECTED]> 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 che
Hi Everybody,
I experienced something a bit strange.
When I issued, on a linux machine, the following
command as user postgres:
~/bin/pg_ctl -D ~/bin reload
It wasn't happy. The complaint was:
pg_ctl: PID file "/usr/local/pgsql/bin/postmaster.pid" does not exist
Is server running?
Up