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
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 |