Postgres Pro
Downloads
Home   >   mailing lists

Re: Cannot restore dumps made with -Fc and --column-inserts - Mailing list pgsql-admin

From Tom Lane
Subject Re: Cannot restore dumps made with -Fc and --column-inserts
Date
Msg-id 18040.1325700844@sss.pgh.pa.us
Whole thread Raw
In response to Cannot restore dumps made with -Fc and --column-inserts  (Dick Visser <visser@terena.org>)
Responses Re: Cannot restore dumps made with -Fc and --column-inserts  (Dick Visser <visser@terena.org>)
List pgsql-admin
Tree view 
Dick Visser <visser@terena.org> writes:
> Running pg on Ubuntu 10.04 64bit, which is 8.4.9 today.
> When I do a pg_dump using --column-inserts, the subsequent restore fails:

Ugh ... I think I broke this :-(.

As a workaround, you can ask pg_restore for plain text output and
pipe that to psql.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Benjamin Krajmalnik"
Date:
Subject: Re: Problem with pgstat timeouts
Next
From: "Kevin Grittner"
Date:
Subject: Re: Problem with pgstat timeouts