[GENERAL] about pg_dump with --blobs

2005-08-11 Thread Howard Kao
Hi all, We have a big database, around 1.2GB, and want to back it up. We used pg_dump with --blobs for large objects. However, the process cannot be completed and threw an error. Can anyone please elaborate on the --blobs, or backing up for large databases? Judging from the description of -b/-

Re: [GENERAL] about pg_dump with --blobs

2005-08-11 Thread Howard Kao
Sorry, forgot the error message. Basically we tried to restore a db and the following error message occurred: pg_restore: [archiver (db)] could not execute query: ERROR: invalid memory alloc request size 1836016426 On 8/11/05, Howard Kao <[EMAIL PROTECTED]> wrote: > Hi all, > > We have a big d

Re: [GENERAL] about pg_dump with --blobs

2005-08-11 Thread Richard Huxton
Howard Kao wrote: Sorry, forgot the error message. Basically we tried to restore a db and the following error message occurred: pg_restore: [archiver (db)] could not execute query: ERROR: invalid memory alloc request size 1836016426 I take it you don't have an object 1.8GBs in size? Do you

Re: [GENERAL] about pg_dump with --blobs

2005-08-11 Thread Tom Lane
Howard Kao <[EMAIL PROTECTED]> writes: > Basically we tried to restore a db and the following error message occurred: > pg_restore: [archiver (db)] could not execute query: ERROR: invalid > memory alloc request size 1836016426 I'm wondering about corruption of the dump file. I don't think either