Re: Connection Error during Pg_restore

On 17/08/2011 7:02 PM, Rebecca Clarke wrote:
> Hi there
>
> I'm doing a restore of a large table. The backup file is 18gb. When I
> run the restore after sometime it comes up with this error while it is
> restoring the data.
>
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 3022; 0 4287406059
> TABLE DATA tbl_exampletable postgres
> pg_restore: [archiver (db)] COPY failed: server closed the connection
> unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.

You'll need to look at the server logs to see why the server terminated
the connection. I expect you'll see a backend crash, but it's hard to be
sure.

Please also supply your version and the other basic information listed here:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems#Things_you_need_to_mention_in_problem_reports

--
Craig Ringer