Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4D2849FA344 for ; Thu, 4 Jan 2007 07:26:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 18418-07 for ; Thu, 4 Jan 2007 07:26:46 -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 C8CD19F938C for ; Thu, 4 Jan 2007 07:26:46 -0400 (AST) Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1H2Qk9-0000Lu-RG for pgsql-general@postgresql.org; Thu, 04 Jan 2007 03:26:45 -0800 Message-ID: <8156139.post@talk.nabble.com> Date: Thu, 4 Jan 2007 01:20:10 -0800 (PST) From: JTyrrell To: pgsql-general@postgresql.org Subject: Re: pg_dump problems In-Reply-To: <459BFD8D.4030100@archonet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: jtyrrell_@hotmail.com References: <8138723.post@talk.nabble.com> <459BFD8D.4030100@archonet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.438 tagged_above=0 required=5 tests=AWL, BAYES_40, FORGED_HOTMAIL_RCVD2, SPF_HELO_PASS, SPF_PASS X-Spam-Level: * X-Archive-Number: 200701/149 X-Sequence-Number: 106689 Richard Huxton wrote: > > JTyrrell wrote: >> >> 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. > > Should work just fine. > 1. Does "pg_dump -s" work? > 2. Does the user you run this as have permission to dump data from "root"? > > -- > Richard Huxton > Archonet Ltd > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > 1. pg_dump -s doesn't work. I've tried using a load of other options and none at all but no luck. 2. I'm running as root so wont be a problem there, and the file im dumping to has full permissions for everyone. What makes this even more confusing is I tried pg_dump with a database name that doesnt exist and tried dumping from database root with a user that doesn't have permission to do that. Both gave the same results as before. Its basically creating the file i need, looking for the database and not finding it. When you dump an empty database the file at least has some info on session authorization and the schema. Im getting nothing! -- View this message in context: http://www.nabble.com/pg_dump-problems-tf2912789.html#a8156139 Sent from the PostgreSQL - general mailing list archive at Nabble.com.