Postgres Pro
Downloads
Home   >   mailing lists

Re: How to setup client auth? - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: How to setup client auth?
Date
Msg-id 20081217060856.GA31285@a-kretschmer.de
Whole thread Raw
In response to How to setup client auth?  ("丰上" <frankwind2006@gmail.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "丰上"
Date:
Subject: How to setup client auth?
Next
From: Thomas Harold
Date:
Subject: Basic PostgreSQL administration questions? (pg_hba.conf, roles, grants, etc)