Postgres Pro
Downloads
Home   >   mailing lists

Re: out of memory in backup and restore - Mailing list pgsql-admin

From Shoaib Mir
Subject Re: out of memory in backup and restore
Date
Msg-id bf54be870612150319x90ea963hf2b0c3443139ad3e@mail.gmail.com
Whole thread Raw
In response to out of memory in backup and restore  (Thomas Markus <t.markus@proventis.net>)
Responses Re: out of memory in backup and restore  (Thomas Markus <t.markus@proventis.net>)
List pgsql-admin
Tree view
Can you please show the dbserver logs and syslog at the same time when it goes out of memory...

Also how much is available RAM you have and the SHMMAX set?

------------
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)

On 12/15/06, Thomas Markus <t.markus@proventis.net> wrote:
Hi,

i'm running pg 8.1.0 on a debian linux (64bit) box (dual xeon 8gb ram)
pg_dump creates an error when exporting a large table with blobs
(largest blob is 180mb)

error is:
pg_dump: ERROR:  out of memory
DETAIL:  Failed on request of size 1073741823.
pg_dump: SQL command to dump the contents of table "downloads" failed:
PQendcopy() failed.
pg_dump: Error message from server: ERROR:  out of memory
DETAIL:  Failed on request of size 1073741823.
pg_dump: The command was: COPY public.downloads ...  TO stdout;

if i try pg_dump with -d dump runs with all types (c,t,p), but i cant
restore (out of memory error or corrupt tar header at ...)

how can i backup (and restore) such a db?

kr
Thomas

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

pgsql-admin by date:

Previous
From: Thomas Markus
Date:
Subject: out of memory in backup and restore
Next
From: Thomas Markus
Date:
Subject: Re: out of memory in backup and restore