agora inbox for pgsql-general@postgresql.org
help / color / mirror / Atom feedFrom: JTyrrell <jtyrrell_@hotmail.com>
To: pgsql-general@postgresql.org
Subject: Re: pg_dump problems
Date: Thu, 4 Jan 2007 01:20:10 -0800 (PST)
Message-ID: <8156139.post@talk.nabble.com> (raw)
In-Reply-To: <459BFD8D.4030100@archonet.com>
References: <8138723.post@talk.nabble.com>
<459BFD8D.4030100@archonet.com>
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.
view thread (20+ messages) latest in thread
Message-ID: <8156139.post@talk.nabble.com>
Permalink: ../8156139.post@talk.nabble.com/
Also on: postgresql.org/message-id/8156139.post@talk.nabble.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: jtyrrell_@hotmail.com
Subject: Re: pg_dump problems
In-Reply-To: <8156139.post@talk.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox