Re: [BUGS] BUG #2645: pg_restore crashes

2006-12-14 Thread Andrew MacLeod
I observed this symptom with a 4Mb .backup file (details of commands issued below). The restore always failed at the same rogue table. On going back to the source DB, I experienced trouble on that table: vacuum worked, but vacuum FREEZE hung after which SELECT count(*) hung! In my case, the "w

Re: [BUGS] BUG #2645: pg_restore crashes

2006-09-24 Thread Tom Lane
"Thomas Verchow" <[EMAIL PROTECTED]> writes: > pg_restore ends with ,,Segmentation fault'' or ,,out of memory'' while > trying to restore a large custom-archive-backup (~ 30 GB). Can you provide a test case for this? Perhaps a SQL script to generate a database full of junk data, which when dumped