Re: pg_hba.conf problem

From: David Nedrow <listbox(at)nedron(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_hba.conf problem
Date: 2003-12-02 02:45:53
Message-ID: A5C5ADEE-2471-11D8-AEEE-003065B331C2@nedron.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Nov 30, 2003, at 21:01, Tom Lane wrote:

> The only other idea I can think of is he's editing the wrong
> pg_hba.conf
> file; we've seen a couple of people make that mistake. (David, the
> right pg_hba.conf file is the one in the $PGDATA directory. If you
> don't see a postmaster.pid file in the same directory that appears and
> disappears when you start and stop the postmaster, then you're in the
> wrong directory ...)

Ta-Da!

That was it. For some reason, I had an old pgsql/data tree laying
around that I was futzing with. Looking for postmaster.pid did the
trick.

What I can't figure out is how I was breaking "local" access by editing
the non-local file. Maybe I was just too tired after 18 hours of
debugging Mozilla stuff. <G>

Thanks for the help.

-David

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Bartlett 2003-12-02 02:48:51 language war
Previous Message Jonathan Bartlett 2003-12-02 02:44:14 Re: Triggers, Stored Procedures, PHP. was: Re: PostgreSQL