[BUGS] Pg_dump Backup Drops a Few Things

2002-07-17 Thread Josh Berkus
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, complex databases was not getting backed up. However, I could not say conclusively that this was the case, as it was always possible that I had missed so

Re: [BUGS] Pg_dump Backup Drops a Few Things

2002-07-17 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > Today I just got done with a very painful restore. PG_dump had failed to back > up a small view on which 6 other views and functions depended, and I had to > spend several hours editing the 99mb backup file by hand. Urgh. > I'd like to work with someo

Re: [BUGS] Pg_dump Backup Drops a Few Things

2002-07-17 Thread Philip Warner
At 13:08 16/07/2002 -0700, Josh Berkus wrote: >I'd like to work with someone on pinpointing the problem, as obviously this >could be a critical issue for production databases. However, I'm not sure >how to submit the files as they are very large (> 90mb) and how can I send >the original databas

Re: [BUGS] Pg_dump Backup Drops a Few Things

2002-07-17 Thread Philip Warner
At 17:21 17/07/2002 -0700, Josh Berkus wrote: > > We can remove (3) by just doing a schema-only dump of the original DB. If > > this works, we know it's data related. Ugh. > >It's not data related ... the missing object is a view. I actually meant here that it may be that dumping the data may som