Re: Problems shutting down Postmaster

Andrew Edson wrote:
> 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
> <http://us.rd.yahoo.com/evt=43909/*http://mobile.yahoo.com/mail> and
> always stay connected
> <http://us.rd.yahoo.com/evt=43909/*http://mobile.yahoo.com/mail> to
> friends.

Take a look at the -m option for pg_ctl