agora inbox for pgsql-general@postgresql.org  

help / color / mirror / Atom feed

From: JTyrrell <jtyrrell_@hotmail.com>
To: pgsql-general@postgresql.org
Subject: pg_dump problems
Date: Wed, 3 Jan 2007 02:55:24 -0800 (PST)
Message-ID: <8138723.post@talk.nabble.com> (raw)


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.

view thread (20+ messages)  latest in thread

Message-ID: <8138723.post@talk.nabble.com>
Permalink:  ../8138723.post@talk.nabble.com/
Also on:    postgresql.org/message-id/8138723.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: <8138723.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