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 CE1A98B9EC4 for ; Thu, 10 Feb 2005 22:00:35 +0000 (GMT) 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 03455-08 for ; Thu, 10 Feb 2005 22:00:05 +0000 (GMT) Received: from 9.hellooperator.net (cpc3-cdif2-3-0-cust202.cdif.cable.ntl.com [81.103.32.202]) by svr1.postgresql.org (Postfix) with ESMTP id 6B0B78BA043 for ; Thu, 10 Feb 2005 22:00:06 +0000 (GMT) Received: from [10.4.0.5] (helo=eris.tenfour) by 9.hellooperator.net with esmtp (Exim 4.43) id 1CzMLx-0003a0-2H for pgsql-admin@postgresql.org; Thu, 10 Feb 2005 22:00:04 +0000 Received: from rasputnik by eris.tenfour with local (Exim 4.44 (FreeBSD)) id 1CzMLw-000DSl-V7 for pgsql-admin@postgresql.org; Thu, 10 Feb 2005 22:00:00 +0000 Date: Thu, 10 Feb 2005 22:00:00 +0000 From: Dick Davies To: PostgreSQL Admin Subject: automating remote pg_dump Message-ID: <20050210220000.GE35853@eris.tenfour> Reply-To: Dick Davies Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.548 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: * X-Archive-Number: 200502/92 X-Sequence-Number: 16260 I notice pg_dump does'nt have a '-P' flag to provide a password, so I assume you generally use it to pull data through a socket. I need to run it remotely (to dump a live db and clone its structure to a test db for unit testing), has anyone got a way to do this? I've tried 'echo pass | pg_dump -h host -U user dbname' , but she doesnae like it.... extra points for answers that don't include the word 'expect' :D -- 'Ugh, it's like there's a party in my mouth and everyone's throwing up.' -- Fry Rasputin :: Jack of All Trades - Master of Nuns