Thread: how pg_hba.conf

how pg_hba.conf

From
"shyju c.k"
Date:
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
 
 
thx

Re: how pg_hba.conf

From
Richard Huxton
Date:
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