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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
