On Fri, 9 Jun 2006, Jeff Frost wrote:
Got the REINDEX completed and found a new error that I haven't seen before:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: Memory exhausted in
AllocSetAlloc(96)
pg_dump: The command was: FETCH 100 IN blobcmt
pg_dumpall: pg_dump failed on database "vsl_cs", exiting
I was dumping like so:
/usr/local/pgsql-8.1.4/bin/pg_dumpall | /usr/bin/bzip2 >
vsl_cs-20060608.sql.bz2
Would it be better and more efficient to just pg_dumpall the globals and
pg_dump in custom format the vsl_cs db? There's actually only one DB on the
systems besides the system dbs. Server is 7.3.2, and the plan is to upgrade
it.
Hit send before i was done:
ulimit -d shows:
bash-2.05b$ ulimit -d
unlimited
The free output on the system looks like this:
bash-2.05b$ free
total used free shared buffers cached
Mem: 1031024 481548 549476 0 30620 359524
-/+ buffers/cache: 91404 939620
Swap: 2562328 193992 2368336
--
Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
