Re: Problems shutting down Postmaster

From: Richard Troy <rtroy(at)ScienceTools(dot)com>
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 22:00:00
Message-ID: Pine.LNX.4.33.0702081356460.13334-100000@denzel.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Thu, 8 Feb 2007, Andrew Edson wrote:
<snip>
> 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.

Try telling Postgres about your new pg_hba.cfg file by using

pg_ctl reload

I'm not aware why you couldn't just stop it with

pg_ctl stop

even with the wrong pg_hba.conf file.

HTH,
Richard

--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
rtroy(at)ScienceTools(dot)com, http://ScienceTools.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rodrigo Gonzalez 2007-02-08 22:37:28 Re: Problems shutting down Postmaster
Previous Message Alvaro Herrera 2007-02-08 21:58:20 Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9