Re: about pg_dump with --blobs

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 <fatearthling(at)gmail(dot)com> wrote:
> 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/--blobs we suspect that it has something to do with
> some fields being text. If anyone has some insight on this help would
> be much appreciated. Thanks.
>