Sender: reina@nsi.edu
Message-ID: <379F821C.761F6334@nsi.edu>
Date: Wed, 28 Jul 1999 15:20:12 -0700
From: "G. Anthony Reina" <reina@nsi.edu>
Organization: The Neurosciences Institute
MIME-Version: 1.0
To: pgsql-hackers@postgresql.org
Subject: pg_dump not dumping all tables
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I just installed 6.5.1 on my RH 6.0 PII/400 MHz machine. I had
previously been running the database on 6.4.2 and had several backups
made through pgdump. When I tried to restore the database (i.e. psql -e
db01 < db.backup) all of the tables were created, but only some of them
had data. These tables are just real tables, not views or anything
strange. Luckily, I also had a back up where I had pg_dump'ed each table
separately (so I'm not in a total jam). But I can't figure out why the
pg_dump didn't backup all of the data.

-Tony Reina