pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Vishal Arora <aroravishal22@hotmail.com>
To: Kawecki_Lewis@emc.com
Cc: pgsql-admin@postgresql.org
Subject: Re: Correct configuration to access Postgres 7.3 from remote client?
Date: Fri, 06 Jul 2007 04:20:18 +0000
Message-ID: <BAY123-F1561A2AAB9CBB0BB536BAAA9010@phx.gbl> (raw)
In-Reply-To: <21503149CFC0C74B9982D9275EDEA06C03CA34C0@CORPUSMX10A.corp.emc.com>




>From: Kawecki_Lewis@emc.com
>To: <pgsql-admin@postgresql.org>
>Subject: [ADMIN] Correct configuration to access Postgres 7.3 from remote 
>client?
>Date: Tue, 3 Jul 2007 20:42:27 -0400
>
>First, I modified these lines in the postgresql.conf file:
>tcpip_socket = true
>port = 5432
>virtual_host = '20.20.20.4, localhost'

You can make it listen on all clients, Or add the client IP in virtual host 
to listen.

>
>where 20.20.20.4 is the address of the postgres server.  Is this needed?
>
>Second, I modified pg_hba.conf and added this line:
>host   all   all   20.20.20.5  255.255.255.0  trust
>
>where 20.20.20.5 is the client machine that I need to access the
>database from.
>
>Then I call "pg_ctl reload -D data_directory" to reload the config file
>changes.
>
>Then from the client I issue:
>
>pg_dump --host=20.20.20.4 -o mydb > remotedump
>pg_dump: [archiver (db)] connection to database "mydb" failed: could not
>connect to server: Connection refused
>         Is the server running on host "10.10.18.53" and accepting
>         TCP/IP connections on port 5432?
>
>It looks like the server is not configured properly.  Does anyone know
>what I am missing?
>
>One strange thing is the postmaster.opts file contains the following:
>
>  cat postmaster.opts
>/usr/bin/postmaster '-i' '-h' '127.0.0.1'
>
>I though it would contain '-h' '20.20.20.4, 127.0.0.1' because of my
>virtual_host setting.
>
>Any help would be greatly appreciated.
>
>Lewis Kawecki
>E: kawecki_lewis@emc.com
>

_________________________________________________________________
Local listings, incredible imagery, and driving directions - all in one 
place! http://maps.live.com/?wip=69&FORM=MGAC01




view thread (2+ messages)

Message-ID: <BAY123-F1561A2AAB9CBB0BB536BAAA9010@phx.gbl>
Permalink:  ../BAY123-F1561A2AAB9CBB0BB536BAAA9010@phx.gbl/
Also on:    postgresql.org/message-id/BAY123-F1561A2AAB9CBB0BB536BAAA9010@phx.gbl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: aroravishal22@hotmail.com, Kawecki_Lewis@emc.com
  Subject: Re: Correct configuration to access Postgres 7.3 from remote client?
  In-Reply-To: <BAY123-F1561A2AAB9CBB0BB536BAAA9010@phx.gbl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox