Skip site navigation (1) Skip section navigation (2)

Re: pg_hba.conf and user files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: brook(at)biology(dot)nmsu(dot)edu
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_hba.conf and user files
Date: 2004-02-27 06:05:43
Message-ID: 17104.1077861943@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
<brook(at)biology(dot)nmsu(dot)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

In response to

pgsql-admin by date

Next:From: Jyry KuukkanenDate: 2004-02-27 06:25:06
Subject: Re: Any Gentoo users interested in a slotted PostgreSQL
Previous:From: John AllgoodDate: 2004-02-27 03:20:54
Subject: Running Multiple Postmasters

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group