pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres will not shutdown?
2+ messages / 2 participants
[nested] [flat]
* Postgres will not shutdown?
@ 2008-05-27 14:22 Carol Walter <walterc@indiana.edu>
2008-05-27 18:20 ` Re: Postgres will not shutdown? Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Carol Walter @ 2008-05-27 14:22 UTC (permalink / raw)
To: pgsql-admin
Hello,
I've had a number of problems with Postgres in passed few days.
First ,I had an issue with a corrupt index. One solution required
that I stop and start postgres so it would read the postgresql.conf
file. It looked like it was stopping but it wasn't. I finally had
to kill the processes. The problem was that postgres didn't thing
the pg_ctl was running. Then I realized I had not set the parameter
that I needed to set quite high enough so I had to stop and restart
it again. It didn't stop again but this time I got the following
message:
# /etc/init.d/cswpostgres stop
Stopping PostgreSQL database...
waiting for server to shut
down...............................................................
failed
pg_ctl: server does not shut down
Can anyone help unravel this?
Thanks in advance,
Carol
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgres will not shutdown?
2008-05-27 14:22 Postgres will not shutdown? Carol Walter <walterc@indiana.edu>
@ 2008-05-27 18:20 ` Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2008-05-27 18:20 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
On Tue, May 27, 2008 at 8:22 AM, Carol Walter <walterc@indiana.edu> wrote:
> Hello,
>
> I've had a number of problems with Postgres in passed few days. First ,I
> had an issue with a corrupt index. One solution required that I stop and
> start postgres so it would read the postgresql.conf file. It looked like it
> was stopping but it wasn't. I finally had to kill the processes. The
> problem was that postgres didn't thing the pg_ctl was running. Then I
> realized I had not set the parameter that I needed to set quite high enough
> so I had to stop and restart it again. It didn't stop again but this time I
> got the following message:
>
> # /etc/init.d/cswpostgres stop
> Stopping PostgreSQL database...
> waiting for server to shut
> down............................................................... failed
> pg_ctl: server does not shut down
>
> Can anyone help unravel this?
more than likely your initscript is calling pg_ctl -D datadir stop
In pg_ctl there's a -m switch with 3 args that can let you stop
postgresql faster. The three args are smart, fast, and immediate.
Smart, the default waits for the clients to disconnect, fast
disconnects the clients, which rolls back their transactions, then
shuts down pg, Immediate kills all the postgres backends and requires
that the db recover on restart.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-05-27 18:20 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-05-27 14:22 Postgres will not shutdown? Carol Walter <walterc@indiana.edu>
2008-05-27 18:20 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox