pg_dump problems

From: JTyrrell <jtyrrell_(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump problems
Date: 2007-01-03 10:55:24
Message-ID: 8138723.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2007-01-03 11:24:12 database design and refactoring
Previous Message Richard Huxton 2007-01-03 10:55:03 Re: Index Scanning