Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6B94F9FA31E for ; Wed, 3 Jan 2007 06:55:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 34762-01-4 for ; Wed, 3 Jan 2007 06:55:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from talk.nabble.com (www.nabble.com [72.21.53.35]) by postgresql.org (Postfix) with ESMTP id C08179FA2D3 for ; Wed, 3 Jan 2007 06:55:25 -0400 (AST) Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1H23mG-0005F9-Mb for pgsql-general@postgresql.org; Wed, 03 Jan 2007 02:55:24 -0800 Message-ID: <8138723.post@talk.nabble.com> Date: Wed, 3 Jan 2007 02:55:24 -0800 (PST) From: JTyrrell To: pgsql-general@postgresql.org Subject: pg_dump problems MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: jtyrrell_@hotmail.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.161 tagged_above=0 required=5 tests=BAYES_50, FORGED_HOTMAIL_RCVD2, SPF_HELO_PASS, SPF_PASS X-Spam-Level: * X-Archive-Number: 200701/95 X-Sequence-Number: 106635 Hi everyone, I'm having problems using pg_dump. When I run the command pg_dump -a -d testrig > testrig.data on a machine running postgresql 7.4.13 with database testirg i have no problem. Then, I want to do the same but on a different machine running postgresql 7.4.6 with database root. So... pg_dump -a -d root > root.data For some reason this doesnt work! The command is running without error, but the file root.data is always empty. The database does exist and all the data is there, and I can run psql and do everything I normally do. I've tried pg_dump with other databases and still get an empty file. Could it be the commands are different for the different versions? If thats the case, does anyone know what command I should be running? -- View this message in context: http://www.nabble.com/pg_dump-problems-tf2912789.html#a8138723 Sent from the PostgreSQL - general mailing list archive at Nabble.com.