dump/restore bytea fields

From: "David Parker" <dparker(at)tazznetworks(dot)com>
To: "postgres general" <pgsql-general(at)postgresql(dot)org>
Subject: dump/restore bytea fields
Date: 2005-06-22 20:05:07
Message-ID: 07FDEE0ED7455A48AC42AC2070EDFF7C817F09@corpsrv2.tazznetworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In 7.4.5 I'm trying to dump and selectively load a database that
contains bytea fields. I dumped it with the command:

pg_dump -p 24000 -Fc -f /home/dparker/temp/tazz.dmp tazz

When I try to restore it, after having generated/modified a list-file, I
get the following error:

% pg_restore -p 24600 -a -d tazz -L ./tazz.toc
/home/dparker/temp/tazz.dmp
pg_restore: ERROR: out of memory
DETAIL: Failed on request of size 8388608.
CONTEXT: COPY library, line 1: "137
DD93266ED40DC09A6B502DB31A254168 1.0.0 agents.so
library t \\177ELF\\001\\001\\..."
pg_restore: [archiver (db)] error returned by PQendcopy

What am I missing?

Thanks!

- DAP
------------------------------------------------------------------------
----------
David Parker Tazz Networks (401) 709-5130


Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2005-06-22 20:24:35 Re: [HACKERS] [PATCHES] Removing Kerberos 4
Previous Message Greg Stark 2005-06-22 19:50:10 Re: [HACKERS] [PATCHES] Removing Kerberos 4