pg_hba.conf and user files

From: <brook(at)biology(dot)nmsu(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_hba.conf and user files
Date: 2004-02-23 21:05:45
Message-ID: 16442.27433.659944.973586@viola.nmsu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Derek Dilts 2004-02-23 21:27:22 psql command to find open statements
Previous Message Louie Kwan 2004-02-23 19:57:31 "SELECT ANY TABLE" !!