=?ISO-8859-1?Q?Jos=E9_Roberto_Motta_Garcia?= <[EMAIL PROTECTED]> writes:
> Could someone answer me what those number in postmaster.pid file means?
They're the key and ID for the shared memory segment. I forget which
is which, but "ipcs" should show them.
regards, tom lane
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
