Re: pg_dump fails with socket_not_open - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump fails with socket_not_open
Date
Msg-id 15897.1111249309@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump fails with socket_not_open  (Sarah Ewen <sarah@thaum.net>)
Responses Re: pg_dump fails with socket_not_open
List pgsql-general
Sarah Ewen <sarah@thaum.net> writes:
> 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

Is this repeatable?  What shows up in the postmaster's log when it
happens?  What platform is this on, and what version of Postgres?

            regards, tom lane

pgsql-general by date:

Previous
From: Benjamin Smith
Date:
Subject: pseudo-serial values in dual primary key?
Next
From: Greg Stark
Date:
Subject: Re: pseudo-serial values in dual primary key?