pg_dump on older version of postgres eating huge amounts of memory

From: Steve Krall <swalker(at)iglou(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump on older version of postgres eating huge amounts of memory
Date: 2004-03-19 00:37:54
Message-ID: Pine.LNX.4.58.0403181921380.24217@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm in a bit of a bad spot. We have a number of remotely deployed
postgres servers. We are very happy with the depenability of postgres,
but have recently run into a problem with pg_dump in SOME of the servers.

When doing a pg_dump databasename > file.dmp pg_dump eats up all the
memory, and is eventually killed because it takes
up a huge amount of memory. The dump file is always 0 bytes. It works
perfectly fine on our other server.

When we run pg_dump in verbose mode, it is trying to get the trigger
information.

Does anybody have any clue what could
be happening? Or even how I can help determine the problem? The machines
are only accessable to us by modem dialup.

Postgres Version 7.1.2 ( Yes, I know it's ancient - but again - these are
a number of servers remotely deployed... )
Redhat 7.1 ( see above ).

I know this is an old version of postgres, but I would really appreciate
any help I can get trying to track this down.

Steve

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-03-19 01:06:32 Re: pg_dump on older version of postgres eating huge amounts of memory
Previous Message Francisco Reyes 2004-03-18 23:27:58 Re: Huge number of raws