Re: Pg_dump very large database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nikolay Mihaylov" <nmmm(at)nmmm(dot)nu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Pg_dump very large database
Date: 2002-03-01 20:09:24
Message-ID: 472.1015013364@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Nikolay Mihaylov" <nmmm(at)nmmm(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2002-03-01 20:44:39 Database is slow, vacuum hangs
Previous Message Zhang, Anna 2002-03-01 17:43:22 pgaccess of postgres 7.2