Re: pg_hba changes not honored

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_hba changes not honored
Date: 2006-08-23 23:08:15
Message-ID: 6992E470F12A444BB787B5C937B9D4DF0574FF4B@ca-mail1.cis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Pg_ctl is pointing to the same directory that postmaster points to on
startup. There is only 1 data directory/postgres installation that I
use.

Pg_ctl informs that postmaster is signaled. When I see the logs for
postmaster, it says "received SIGHUP, reloading configuration files"

Linux 2.4.21-40.ELsmp #1 SMP Thu Feb 2 22:22:39 EST 2006 i686 i686 i386
GNU/Linux

Postgres 8.1.2

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, August 23, 2006 4:00 PM
To: Sriram Dandapani
Cc: Joshua D. Drake; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] pg_hba changes not honored

"Sriram Dandapani" <sdandapani(at)counterpane(dot)com> writes:
> This problem occurs only when the changes are made while postmaster is
> running and pg_ctl is used to reload config files.
> When the changes are applied and postmaster is stopped and restarted,
it
> works fine.

Hm. OK, that means we need to look closer at how you're using pg_ctl.
Are you sure you're pointing it at the right data directory? Does it
claim to have successfully signaled the postmaster? What PG version
is this exactly, and on what platform?

regards, tom lane

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-08-23 23:39:02 Re: pg_hba changes not honored
Previous Message Tom Lane 2006-08-23 22:59:36 Re: pg_hba changes not honored