PQgetCopyData() failed - corruption? - Mailing list pgsql-general

From François Beausoleil
Subject PQgetCopyData() failed - corruption?
Date
Msg-id 19E62724-A7C0-4F83-B220-E57131A98F12@teksol.info
Whole thread Raw
Responses Re: PQgetCopyData() failed - corruption?
List pgsql-general
Hello list,

I received the following error while backing up my database:

pg_dump: Dumping the contents of table "summary_show_unique_personas_2012_10_15" failed: PQgetCopyData() failed.
pg_dump: Error message from server: pg_dump: The command was: COPY public.summary_show_unique_personas_2012_10_15
(market_id,period, show_id, service_id, service_name, gender, followers_count, interactions_count) TO stdout; 

The pg_dump occurs over the network, from a client machine. The connection between both machines goes over the public
Internet,but is in the same physical data center. 

If I SSH onto the database server, I can dump that specific table without problem, and I'm trying a full backup right
now. 

I've found http://www.symantec.com/connect/forums/puredisk-disaster-recovery-backup-failed which talks about a product
usingPostgreSQL.  The archives of this list do not have a reference to "PGgetCopyData", nor StackOverflow,
dba.stackexchangeor ServerFault. 

Does that error indicate a database corruption? Or just a network interruption?

Thanks!
François Beausoleil
Attachment

pgsql-general by date:

Previous
From: Ned Wolpert
Date:
Subject: Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: What's wrong with postgresql.org domain?