pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_hba.conf and user files
2+ messages / 2 participants
[nested] [flat]

* pg_hba.conf and user files
@ 2004-02-23 21:05  brook@biology.nmsu.edu
  0 siblings, 1 reply; 2+ messages in thread

From: brook@biology.nmsu.edu @ 2004-02-23 21:05 UTC (permalink / raw)
  To: pgsql-admin

I am trying to set up pg_hba.conf for PostgreSQL 7.3.  I want to limit
access to a database from a host to the set of users in a file.  The
documentation suggests that this is done as follows:

	host dbname @user_file 10.0.1.12 255.255.255.255 md5

However, the postmaster complains of a syntax error for lines such as
this.  There is in fact a file of the appropriate name (user_file in
same directory as pg_hba.conf), readable by the backend.  It contains
a list of user names, one per line.

Is this the correct setup?  If not, how is this supposed to be
accomplished?

Thanks for your help.

Cheers,
Brook



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: pg_hba.conf and user files
@ 2004-02-27 06:05  Tom Lane <tgl@sss.pgh.pa.us>
  parent: brook@biology.nmsu.edu
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-02-27 06:05 UTC (permalink / raw)
  To: brook@biology.nmsu.edu; +Cc: pgsql-admin

<brook@biology.nmsu.edu> writes:
> I am trying to set up pg_hba.conf for PostgreSQL 7.3.  I want to limit
> access to a database from a host to the set of users in a file.  The
> documentation suggests that this is done as follows:

> 	host dbname @user_file 10.0.1.12 255.255.255.255 md5

> However, the postmaster complains of a syntax error for lines such as
> this.

Hm, looks all right to me.  What's the *exact* error message?  Also,
please look in the postmaster's log (stderr or syslog); there may be
more info there than is reported to the client.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-02-27 06:05 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-23 21:05 pg_hba.conf and user files brook@biology.nmsu.edu
2004-02-27 06:05 ` Tom Lane <tgl@sss.pgh.pa.us>

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