| From: | Rebecca Clarke <rebecca(at)clarke(dot)net(dot)nz> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Connection Error during Pg_restore |
| Date: | 2011-08-17 11:02:30 |
| Message-ID: | CANY3h+Q7mUUq2BZ2yi4VDz1tadQMfuUno7xA3QwzA1t=6mYH5Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
WARNING: errors ignored on restore: 1
It will work if I use COPY but the table is so big I need to use pg_dump to
compress it.
Any help would be great.
Thanks
Rebecca
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2011-08-17 11:24:18 | Re: Change master to standby |
| Previous Message | alexondi | 2011-08-17 10:56:29 | Re: Run server recovery |