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@gmail.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.
>