pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump on windows
5+ messages / 3 participants
[nested] [flat]
* pg_dump on windows
@ 2008-02-08 15:56 dghundt@netzero.net <dghundt@netzero.net>
0 siblings, 1 reply; 5+ messages in thread
From: dghundt@netzero.net @ 2008-02-08 15:56 UTC (permalink / raw)
To: pgsql-admin
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...
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_dump on windows
@ 2008-02-08 16:42 Tom Lane <tgl@sss.pgh.pa.us>
parent: dghundt@netzero.net <dghundt@netzero.net>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2008-02-08 16:42 UTC (permalink / raw)
To: dghundt@netzero.net <dghundt@netzero.net>; +Cc: pgsql-admin
"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
^ permalink raw reply [nested|flat] 5+ messages in thread
* pg_dump on windows
@ 2008-02-08 18:30 dghundt@netzero.net <dghundt@netzero.net>
0 siblings, 1 reply; 5+ messages in thread
From: dghundt@netzero.net @ 2008-02-08 18:30 UTC (permalink / raw)
To: pgsql-admin
I pulled up another instance of pgadmin to take a look since the initial instance gave me the windows "not responding" message on the title bar.
In the server status log file I see the following lines right about where my disk and cpu
activity stops and my backup seems to hang. There are no other reports in the log after these three.
LOG unexpected EOF on client connection
LOG unexpected EOF on client connection
LOG unexpected EOF on client connection
Status tab shows:
user querey start querey
postgres 11:35am copy public.<the name of my large table here>
In locks tab
I see about 30 locks listed all for the same large table
They are all for the same start time of 11:35am
Mode: accessShareLock
Granted: yes. they all say yes for granted.
Transactions tab: empty
I would appreciate your help.
David
_____________________________________________________________
Need cash? Click to get an emergency loan, bad credit ok
http://thirdpartyoffers.netzero.net/TGL2211/fc/Ioyw6ijlfjASGwOi5szeQR1lqrOYPiuL14vxA33m9QSB4RF5MNIyD...
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_dump on windows
@ 2008-02-08 20:54 Andrew Sullivan <ajs@crankycanuck.ca>
parent: dghundt@netzero.net <dghundt@netzero.net>
0 siblings, 0 replies; 5+ messages in thread
From: Andrew Sullivan @ 2008-02-08 20:54 UTC (permalink / raw)
To: pgsql-admin
On Fri, Feb 08, 2008 at 06:30:33PM +0000, dghundt@netzero.net wrote:
>
> LOG unexpected EOF on client connection
> LOG unexpected EOF on client connection
> LOG unexpected EOF on client connection
This means the back end thinks the client disappeared.
What is the probability you have a firewall in between your client and the
server? Some of them "helpfully" drop the connection after some period of
"inactivity". Since you're just sitting there waiting for the command to
complete, you look like you have no activity.
> In locks tab
> I see about 30 locks listed all for the same large table
> They are all for the same start time of 11:35am
> Mode: accessShareLock
> Granted: yes. they all say yes for granted.
If they're all granted, you're not waiting for one.
A
^ permalink raw reply [nested|flat] 5+ messages in thread
* pg_dump on windows
@ 2008-02-09 01:38 dghundt@netzero.net <dghundt@netzero.net>
0 siblings, 0 replies; 5+ messages in thread
From: dghundt@netzero.net @ 2008-02-09 01:38 UTC (permalink / raw)
To: pgsql-admin
Firewall is turned off. I use zonealarm, but it is off. Windows firewall is off.
I run pgadmin backup from the pc that is the postgres server. No client applications are running during the backup.
The first 26 tables backup up nearly all the time before it gets to my large table which comprises about 90% of the data.
thank you.
_____________________________________________________________
Need cash? Click to get an emergency loan, bad credit ok
http://thirdpartyoffers.netzero.net/TGL2211/fc/Ioyw6ijlfjASMOLapmGDEwWV0QzysUgo1E9maziLqmQVdDcVy3NBi...
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2008-02-09 01:38 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-08 15:56 pg_dump on windows dghundt@netzero.net <dghundt@netzero.net>
2008-02-08 16:42 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-02-08 18:30 pg_dump on windows dghundt@netzero.net <dghundt@netzero.net>
2008-02-08 20:54 ` Andrew Sullivan <ajs@crankycanuck.ca>
2008-02-09 01:38 pg_dump on windows dghundt@netzero.net <dghundt@netzero.net>
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