pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: dghundt@netzero.net <dghundt@netzero.net>
To: pgsql-admin@postgresql.org
Subject: pg_dump on windows
Date: Fri, 8 Feb 2008 15:56:04 GMT
Message-ID: <20080208.105604.29071.1@webmail24.vgs.untd.com> (raw)

I am using postgres 8.2.6 on windows xp pro sp2.  Of about 80 tables, one is a large binary table containing over 2gb of data.

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.  

We are using a health care record with postgres backend and other people are having the same problem. 
_____________________________________________________________
Own the Ultimate Platinum Credit Card. Click here.
http://thirdpartyoffers.netzero.net/TGL2211/fc/Ioyw6ijldJaAPEMcUmOFzZNdfk9TMs4LECG50diB8qzKXj17ZyjcY...





view thread (5+ messages)  latest in thread

Message-ID: <20080208.105604.29071.1@webmail24.vgs.untd.com>
Permalink:  ../20080208.105604.29071.1@webmail24.vgs.untd.com/
Also on:    postgresql.org/message-id/20080208.105604.29071.1@webmail24.vgs.untd.com

 · 

reply

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: dghundt@netzero.net
  Subject: Re: pg_dump on windows
  In-Reply-To: <20080208.105604.29071.1@webmail24.vgs.untd.com>

* 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