Unable to dump database/table

From: Krok <krok(at)void(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Unable to dump database/table
Date: 2004-10-11 11:27:07
Message-ID: 416A6E0B.7030407@void.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello.

pg_dump cann't dump some databases (at least one table) with the
following error ;

$ pg_dump -b -F c -v -f pgdump_void_2004-10-11T03:04:00 void
pg_dump: saving encoding
pg_dump: saving database definition
pg_dump: reading schemas
pg_dump: reading user-defined types
pg_dump: reading user-defined functions
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined tables
pg_dump: reading table inheritance information
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: finding the columns and types of table ...
...
pg_dump: flagging inherited columns in subtables
pg_dump: dumping out database comment
pg_dump: dumping out user-defined schemas
pg_dump: dumping out user-defined types
pg_dump: dumping out tables
pg_dump: dumping out indexes
pg_dump: dumping out user-defined procedural languages
pg_dump: dumping out user-defined functions
pg_dump: dumping out user-defined aggregate functions
pg_dump: dumping out user-defined operators
pg_dump: dumping out user-defined operator classes
pg_dump: dumping out user-defined casts
pg_dump: preparing to dump the contents of table ...
...
pg_dump: dumping foreign key constraints for table ...
...
pg_dump: dumping triggers for table ...
...
pg_dump: dumping out rules
pg_dump: dumping contents of table ...
...
pg_dump: dumping contents of table users
pg_dump: ERROR: out of memory
DETAIL: Failed on request of size 536870920.
pg_dump: SQL command to dump the contents of table "users" failed:
PQendcopy() failed.
pg_dump: Error message from server: ERROR: out of memory
DETAIL: Failed on request of size 536870920.
pg_dump: The command was: COPY public.users (<fields>) TO stdout;
pg_dump: *** aborted because of error
$

Configuration of server is :
1GB RAM

$ ipc_check

shared memory enabled: 262144 kB available

==========================

semaphores enabled
$ uname -r
4.10-RELEASE-p2
$ pg_config --version
PostgreSQL 7.4.5
$ pg_config --configure
'--with-libraries=/usr/local/lib' '--with-includes=/usr/local/include'
'--enable-nls' '--with-openssl=/usr/local' '--prefix=/usr/local'
'i386-portbld-freebsd4.10' 'LDFLAGS= -rpath=/usr/local/lib
-L/usr/local/lib -lgnugetopt' 'CFLAGS=-O2 -pipe -march=pentiumpro -O3
-funroll-loops' 'CPPFLAGS=-O2 -pipe -fmemoize-lookups -fsave-memoized
-I/usr/local/include' 'host_alias=i386-portbld-freebsd4.10'
'build_alias=i386-portbld-freebsd4.10'
'target_alias=i386-portbld-freebsd4.10' 'CC=cc'
$

I've REINDEX and VACUUM table, but it doesn't help.
Can anybody help with this ?

And a question : is the size, that pg_dump has reported (Failed on
request of size 536870920) is required size of available shared memory ?
If it is, then what ?! I need to have 10GB shared memory to dump table
whith 100'000'000 records ?!

--
With best regards,
Krok

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-10-11 14:17:13 Re: Unable to dump database/table
Previous Message Justin Clift 2004-10-11 02:10:09 Re: Buggy timestamp generation code in PG 7.4.5 on FreeBSD