Re: how pg_hba.conf

From: Richard Huxton <dev(at)archonet(dot)com>
To: "shyju c(dot)k" <newslttr(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how pg_hba.conf
Date: 2006-06-15 07:08:44
Message-ID: 4491077C.6090009@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

shyju c.k wrote:
> hai
>
> have to solve one problem
>
>
> i have two mechine in diffrent network range , one is main database
> server(n/w is 10.1.2.0) and other is back bone server(n/w 10.1.7.0)
> i need to take pg_dump from back bone server .
>
> what configuration needed in pg_hba.conf

On 10.1.2.0 make sure you are listening on for connections from the
internet and add 10.1.7.0 to the list of approved hosts. Something like:

host mydatabase myuser 10.1.7.0/32 trust

You probably don't want "trust" unless both machines and the intervening
network are trusted.

HTH
--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-06-15 07:13:51 Re: how to test my stored procedures?
Previous Message Richard Huxton 2006-06-15 07:06:14 Re: Relation "tablename" does not exist