Problems shutting down Postmaster

From: Andrew Edson <cheighlund(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problems shutting down Postmaster
Date: 2007-02-08 21:32:38
Message-ID: 20070208213238.60815.qmail@web34204.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need to add a system to our postgres pg_hba.conf file; the main server went down a few days ago, and this system was mistakenly left off the list of allowed systems when the server was brought back up. (Older version of the .conf file; I managed to accidentally delete the more current one while trying to copy it for safekeeping. Proves what an idiot I am...)

Someone else added the IP address for the other system to the pg_hba.conf file later, but since we had already started postgres by then, it didn't take. And now, for some reason, postgres doesn't seem to want to let me shut down. I keep getting the following error when trying to shut the postmaster down:

./pg_ctl stop -D /usr/local/pgsql/data/
waiting for postmaster to shut down............................................................... failed
pg_ctl: postmaster does not shut down

I am doing this as the postgres user, so I'm not sure what else I might be doing wrong. Does anyone have any kind of suggestions about how to solve this? Alternately, would someone please let me know of other ways to shut down the postmaster so we can restart it with the updated .conf file?

Thank you for your consideration.


---------------------------------
Don't be flakey. Get Yahoo! Mail for Mobile and
always stay connected to friends.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message MargaretGillon 2007-02-08 21:34:46 Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9
Previous Message Sic Transit Gloria Mundi 2007-02-08 21:03:31 Dumb question - how to tell if autovacuum is doing its job in 8.2.x