Many thanks, Peter.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Peter Koczan [mailto:[EMAIL PROTECTED]
Sent: Thu 3/27/2008 2:59 PM
To: Tena Sakai
Cc: Scott Marlowe; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] it refuses to go down...
> > I had to dea
> > I had to deal with this recently where the
> > status was "notify interrupt"
>
> Is this a response from "pg_ctl status" command?
I'm referring to the last field of "ps ax". For instance, this line...
>13841 ?Rs 234:32 postgres: gadb canon 127.0.0.1(44837) SELECT
would have
Tue 3/25/2008 10:59 AM
To: Tena Sakai
Cc: Scott Marlowe; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] it refuses to go down...
> > did you try pg_ctl -m immediate stop ???
>
> I just did, and it worked.
>
>$ pg_ctl stop -m immediate
>waiting for server to shut do
> > did you try pg_ctl -m immediate stop ???
>
> I just did, and it worked.
>
>$ pg_ctl stop -m immediate
>waiting for server to shut down done
>server stopped
I'd be careful about shutting down using "immediate" mode. It forces
the database into recovery mode.
Your problem co
AIL PROTECTED]
Sent: Mon 3/24/2008 3:37 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] it refuses to go down...
On Mon, Mar 24, 2008 at 3:48 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
>
> Hi Everybody,
>
> I ran out of space over the weekend. /usr/local/ fill
l.org
Subject: Re: [ADMIN] it refuses to go down...
"Tena Sakai" <[EMAIL PROTECTED]> writes:
> $ pg_ctl stop -m fast
> waiting for server to shut
> down... failed
> pg_ctl: server does not shut down
Have
On Mon, Mar 24, 2008 at 3:48 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
>
> Hi Everybody,
>
> I ran out of space over the weekend. /usr/local/ filled up.
> I got a new partition and about 1/2 done with copying the
> data from the filled-up partition. BTW, I am using postgres
> 8.3.0 on dell ha
That's what she said.
Someone had to do it.
That's what she said, again.
Sorry.
-salman
-
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
"Tena Sakai" <[EMAIL PROTECTED]> writes:
> $ pg_ctl stop -m fast
> waiting for server to shut
> down... failed
> pg_ctl: server does not shut down
Have you looked into the postmaster log to see *why* it's not shutting
down?
> Can
Hi Everybody,
I ran out of space over the weekend. /usr/local/ filled up.
I got a new partition and about 1/2 done with copying the
data from the filled-up partition. BTW, I am using postgres
8.3.0 on dell hardware/ redhat advanced server.
I did:
$ pg_ctl status
pg_ctl: server is running (P
10 matches
Mail list logo