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

Re: How to setup client auth?

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to setup client auth?
Date: 2008-12-17 06:08:56
Message-ID: 20081217060856.GA31285@a-kretschmer.de (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: Thomas HaroldDate: 2008-12-17 15:48:18
Subject: Basic PostgreSQL administration questions? (pg_hba.conf, roles, grants, etc)
Previous:From: 丰上Date: 2008-12-17 04:36:14
Subject: How to setup client auth?

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