| From: | RexHsu <rexhsu(at)tom(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_restore problem when restoring big table |
| Date: | 2005-08-26 02:45:10 |
| Message-ID: | 20050826104417.ED62.REXHSU@tom.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Postgresql 8.0.3
Windows XP with SP2
C:\Program Files\PostgreSQL\8.0\bin>pg_restore --dbname=smedb --verbose
--ignore
-version --host=localhost --username=postgres "c:\backup2005-08-08 10
.47.06"
when it was restoring data of one big table,it returned error msg like
[custom archive] can not read data block - unexpected 1, actual 0
then I turned on debug5 mode,it gave me more detail:
2005-08-26 10:22:16 ERROR: 08P01: unexpected message type 0x58 during COPY from stdin
2005-08-26 10:22:16 CONTEXT: COPY t_attachment, line 53: ""
2005-08-26 10:22:16 LOCATION: CopyGetData, copy.c:455
2005-08-26 10:22:16 LOG: XX000: could not send data to client: 由于目标机器积极拒绝,无法连接。
2005-08-26 10:22:16 LOCATION: internal_flush, pqcomm.c:1050
2005-08-26 10:22:16 LOG: XX000: could not receive data from client: 由于目标机器积极拒绝,无法连接。
2005-08-26 10:22:16 LOCATION: pq_recvbuf, pqcomm.c:704
2005-08-26 10:22:16 LOG: 08P01: unexpected EOF on client connection
Is there any problem when to restore big blob data in postgresql?
I dont know how to do now. Any help will be appreciated.
--
RexHsu <rexhsu(at)tom(dot)com>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Caduto | 2005-08-26 03:08:45 | Re: Its Beta Time Again ... 8.1 Beta 1 Now Available |
| Previous Message | Matt A. | 2005-08-26 00:55:30 | Altering built-in functions cast |