Re: Pg_dump very large database - Mailing list pgsql-admin

From Tom Lane
Subject Re: Pg_dump very large database
Date
Msg-id 472.1015013364@sss.pgh.pa.us
Whole thread Raw
In response to Pg_dump very large database  ("Nikolay Mihaylov" <nmmm@nmmm.nu>)
List pgsql-admin
"Nikolay Mihaylov" <nmmm@nmmm.nu> writes:
> I have a database with very large tables - about 2+ GB per table.

> When I'm using pg_dump tool, it get all memory available, then linux
> crash (or kernel kills the most of processes including pg_dump)

This is fixed in 7.2's pg_dump, which as far as I know can be used
safely with 7.1 installations, should you not want to update the whole
installation just yet.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Nikolay Mihaylov"
Date:
Subject: FW: Pg_dump very large database
Next
From: "Nick Fankhauser"
Date:
Subject: Database is slow, vacuum hangs