pg_dump fails with socket_not_open - Mailing list pgsql-general

From Sarah Ewen
Subject pg_dump fails with socket_not_open
Date
Msg-id 953fae4f050318011972ec2ca1@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi there folks,

I've just had pg_dump fail on me for the first time ever, and I'm not sure why.

It generates 24MB of dump before bombing out with:

pg_dump: socket not open
pg_dump: SQL command to dump the contents of table "activity_log"
failed: PQendcopy() failed.
pg_dump: Error message from server: socket not open
pg_dump: The command was: COPY public.activity_log (<bunch of columns>
TO  stdout

Are there any common reasons for seeing this?

I'm fairly sure that the machine is ok hardware wise - any pointers appreciated.

Thanks,

Sarah.

pgsql-general by date:

Previous
From: votetaker@netagw.com (Bill Aten)
Date:
Subject: CFV: comp.databases.postgresql
Next
From: Brent Wood
Date:
Subject: Re: Statistics with PostgreSQL