pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Lew <noone@lwsc.ehost-services.com>
To: pgsql-admin@postgresql.org
Subject: Re: Regarding access to a user
Date: Fri, 22 Aug 2008 19:39:46 -0400
Message-ID: <G7adndSBlO7e0zLVnZ2dnUVZ_hKdnZ2d@comcast.com> (raw)
In-Reply-To: <B3F7216EEA3D5D49A0841DFC6843C33AB9BF0A@HSTMBX004.corp.satyam.ad>
References: <B3F7216EEA3D5D49A0841DFC6843C33AB9BC9B@HSTMBX004.corp.satyam.ad>
	<48ABD192.EE98.0025.0@wicourts.gov>
	<B3F7216EEA3D5D49A0841DFC6843C33AB9BEEE@HSTMBX004.corp.satyam.ad>
	<48AD3037.6060700@batory.org.pl>
	<B3F7216EEA3D5D49A0841DFC6843C33AB9BF0A@HSTMBX004.corp.satyam.ad>

Shashwat_Nigam wrote:
> Dear Tomasz

There are others here, too.

> I had done the same but still the problem is like that the user is able to access all the databases in the current server. Even the order is like same and if I comment the second line(all access) then the error is there.
> Please provide solution for the same.

It sounds like you didn't bump the server.  You have to signal it to re-read 
the pg_hba.conf file.  The link provided by Kevin Grittner

<http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.html;

explains

> The pg_hba.conf file is read on start-up and when the main server process 
> receives a SIGHUP signal. If you edit the file on an active system, you will 
> need to signal the server (using pg_ctl reload or kill -HUP) to make it 
> re-read the file. 

Did you perform that step?

-- 
Lew



view thread (15+ messages)  latest in thread

Message-ID: <G7adndSBlO7e0zLVnZ2dnUVZ_hKdnZ2d@comcast.com>
Permalink:  ../G7adndSBlO7e0zLVnZ2dnUVZ_hKdnZ2d@comcast.com/
Also on:    postgresql.org/message-id/G7adndSBlO7e0zLVnZ2dnUVZ_hKdnZ2d@comcast.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: noone@lwsc.ehost-services.com
  Subject: Re: Regarding access to a user
  In-Reply-To: <G7adndSBlO7e0zLVnZ2dnUVZ_hKdnZ2d@comcast.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox