Pg_dump Backup Drops a Few Things - Mailing list pgsql-bugs

From Josh Berkus
Subject Pg_dump Backup Drops a Few Things
Date
Msg-id 200207161308.19712.josh@agliodbs.com
Whole thread Raw
Responses Re: Pg_dump Backup Drops a Few Things
Re: Pg_dump Backup Drops a Few Things
List pgsql-bugs
Folks,

I am not subscribed to -bugs.  Please e-mail me directly.

For some time on 7.2.1 I have suspected that one or two items from large,=
=20
complex databases was not getting backed up.  However, I could not say=20
conclusively that this was the case, as it was always possible that I had=
=20
missed something somewhere.

Today I just got done with a very painful restore.  PG_dump had failed to b=
ack=20
up a small view on which 6 other views and functions depended, and I had to=
=20
spend several hours editing the 99mb backup file by hand.

I'd like to work with someone on pinpointing the problem, as obviously this=
=20
could be a critical issue for production databases.   However, I'm not sure=
=20
how to submit the files as they are very large (> 90mb) and how can I send=
=20
the original database not as a backup file?

--=20
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-bugs by date:

Previous
From: Jerome Alet
Date:
Subject: Re: drop database doesn't work
Next
From: Tom Lane
Date:
Subject: Re: Pg_dump Backup Drops a Few Things