Thread: dump/restore bytea fields
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
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
Never mind. Appears to have been local to a particular machine. I was able to pg_restore the same dump file on another box (which I should have tried before posting!).... Sorry for the noise.
- DAP
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of David Parker
Sent: Wednesday, June 22, 2005 4:05 PM
To: postgres general
Subject: [GENERAL] dump/restore bytea fieldsIn 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 tazzWhen 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 PQendcopyWhat am I missing?Thanks!- DAP
----------------------------------------------------------------------------------
David Parker Tazz Networks (401) 709-5130