Re: Problems shutting down Postmaster - Mailing list pgsql-general

From Tom Lane
Subject Re: Problems shutting down Postmaster
Date
Msg-id 20088.1170970623@sss.pgh.pa.us
Whole thread Raw
In response to Problems shutting down Postmaster  (Andrew Edson <cheighlund@yahoo.com>)
Responses Re: Problems shutting down Postmaster  (Andrew Edson <cheighlund@yahoo.com>)
List pgsql-general
Andrew Edson <cheighlund@yahoo.com> writes:
>   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.

You don't need to shut down the server to adjust pg_hba.conf ... just
"pg_ctl reload".

> And now, for some reason, postgres doesn't seem to want to let me shut
> down.

A standard shutdown doesn't finish until all existing sessions exit of
their own accord.  Perhaps you wanted "-m fast"?

            regards, tom lane

pgsql-general by date:

Previous
From: MargaretGillon@chromalloy.com
Date:
Subject: Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9
Next
From: Rodrigo Gonzalez
Date:
Subject: Re: Problems shutting down Postmaster