Re: Problems shutting down Postmaster

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Edson <cheighlund(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems shutting down Postmaster
Date: 2007-02-08 21:37:03
Message-ID: 20088.1170970623@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrew Edson <cheighlund(at)yahoo(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Edson 2007-02-08 21:48:39 Re: Problems shutting down Postmaster
Previous Message MargaretGillon 2007-02-08 21:34:46 Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9