Re: Bug #792: pg_dump uses all available RAM and swap

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: stepa(at)openskysoftware(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #792: pg_dump uses all available RAM and swap
Date: 2002-10-01 20:13:10
Message-ID: 15231.1033503190@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> We noticed that doing a pg_dump was taking longer and longer to perform when doing data backup. For this and other reasons, we began doing backup by stopping the server and tarring the data directory. Now, we are trying to upgrade to 7.2.1 and we find that we must do a pg_dump of our data to restore properly, but running pg_dump now causes all available resources to be used up with no output until the system locks up.

> We run postgresql 7.1 on RedHat Linux 7.3

Try using 7.2's pg_dump.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Josh Berkus 2002-10-01 23:57:47 Bug in Function-Transactions?
Previous Message pgsql-bugs 2002-10-01 18:37:51 Bug #792: pg_dump uses all available RAM and swap