Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to setup client auth?

How to setup client auth?

From
"丰上"
Date:
I 'd like to allow only one remote client to connect using plain-text
password from certain IP.
How to do it?How to setup pg_hba.conf or postgresql.conf?
Thanks in advance.

Re: How to setup client auth?

From
"A. Kretschmer"
Date:
In response to ???? :
> I 'd like to allow only one remote client to connect using plain-text
> password from certain IP.
> How to do it?How to setup pg_hba.conf or postgresql.conf?
> Thanks in advance.

pg_hba.conf

Something like:

host    <database>    <user>    <ip/mask>    password

Change the <param> with your values, and read the doc about client-auth:
http://www.postgresql.org/docs/8.3/interactive/client-authentication.html


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net