it refuses to go down...

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: it refuses to go down...
Date: 2008-03-24 21:48:53
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C0378F152@egcrc-ex01.egcrc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 (PID: 11148)
/usr/local/pgsql/bin/postgres

and proceeded with:

$ pg_ctl stop -m fast
waiting for server to shut down............................................................... failed
pg_ctl: server does not shut down

My plan was to shutdown, make sure the env variables are
set correctly and restart. But it refuses to go down as
shown above. I then tried to use psql:
$ psql canon

and it tells me:
psql: FATAL: the database system is shutting down

Can I kill the process 11148 and do as I planned accordingly?

I would appreciate any pointers.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-03-24 22:11:20 Re: it refuses to go down...
Previous Message Scott Marlowe 2008-03-24 17:45:50 Re: Database file names