X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C853553377 for ; Fri, 8 Apr 2005 15:20:47 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29934-02 for ; Fri, 8 Apr 2005 14:20:41 +0000 (GMT) Received: from mail.libertyrms.com (unknown [207.219.45.62]) by svr1.postgresql.org (Postfix) with ESMTP id 4390E53338 for ; Fri, 8 Apr 2005 15:20:40 +0100 (BST) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1DJuLj-0002Xb-QX; Fri, 08 Apr 2005 10:20:43 -0400 Message-ID: <4256933B.8090803@ca.afilias.info> Date: Fri, 08 Apr 2005 10:20:43 -0400 From: Brad Nicholson User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Askar Zaidi Cc: pgsql-admin@postgresql.org Subject: Re: pg_dump on remote machine References: <20050408125139.DC4BD5AF6F5@svr4.postgresql.org> <20050408132127.M86625@mail.nplindia.ernet.in> In-Reply-To: <20050408132127.M86625@mail.nplindia.ernet.in> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.022 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/101 X-Sequence-Number: 17114 Check the pg_hba.conf file to see if you have access to the database, as user that you are trying to connect as, from the IP you are trying to connect from. I'll bet that you don't. Check you postgres error logs, and you should see the refused connection. You might have to tweak the logging settings. Also, the exact error you get would be a bit more helpful. Askar Zaidi wrote: >Hello, >Iam trying to take a dump of my DB from one machine to another in this >fashion: > >on the secondary database: > >pg_dump -b -h 172.16.1.20 (dbname) > /tmp/dump.dump > >my error is : >could not connect to database etc...etc.. > >although the file dump.dump in /tmp is created.(it's empty) > >I can access remote database on my secondary through phpPgAdmin. > >Any clues?? > >Askar Zaidi >Central Computer Facility, >National Physical Laboratory, >New Delhi, India > > >---------------------------(end of broadcast)--------------------------- >TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > > -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.