From: Tom Lane <tgl@sss.pgh.pa.us>
To: dghundt@netzero.net <dghundt@netzero.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump on windows
Date: Fri, 08 Feb 2008 11:42:47 -0500
Message-ID: <2169.1202488967@sss.pgh.pa.us> (raw)
In-Reply-To: <20080208.105604.29071.1@webmail24.vgs.untd.com>
References: <20080208.105604.29071.1@webmail24.vgs.untd.com>
"dghundt@netzero.net" <dghundt@netzero.net> writes:
> Postgres backsup the data and 95% of the time sticks at this table and cpu activity drops from 40-60% to about zero. I can stay there for hours before I just have to stop the attempt.
Have you looked into pg_locks to see if something is holding an
exclusive lock on that table? Have you checked to see if there's
still disk activity?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, dghundt@netzero.net
Subject: Re: pg_dump on windows
In-Reply-To: <2169.1202488967@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox