pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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