Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CD36A9FBA94 for ; Fri, 6 Jul 2007 01:20:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 98385-04 for ; Fri, 6 Jul 2007 01:20:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from bay0-omc3-s31.bay0.hotmail.com (bay0-omc3-s31.bay0.hotmail.com [65.54.246.231]) by postgresql.org (Postfix) with ESMTP id 74C279FB743 for ; Fri, 6 Jul 2007 01:20:24 -0300 (ADT) Received: from hotmail.com ([207.46.11.95]) by bay0-omc3-s31.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Thu, 5 Jul 2007 21:20:23 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 5 Jul 2007 21:20:23 -0700 Message-ID: Received: from 207.46.11.123 by by123fd.bay123.hotmail.msn.com with HTTP; Fri, 06 Jul 2007 04:20:18 GMT X-Originating-IP: [59.160.193.34] X-Originating-Email: [aroravishal22@hotmail.com] X-Sender: aroravishal22@hotmail.com In-Reply-To: <21503149CFC0C74B9982D9275EDEA06C03CA34C0@CORPUSMX10A.corp.emc.com> From: "Vishal Arora" 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 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 06 Jul 2007 04:20:23.0417 (UTC) FILETIME=[F8CDBE90:01C7BF84] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/58 X-Sequence-Number: 26039 >From: Kawecki_Lewis@emc.com >To: >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