Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

pg_restore problem when restoring big table


  • From: RexHsu <rexhsu(at)tom(dot)com>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: pg_restore problem when restoring big table
  • Date: Fri, 26 Aug 2005 10:45:10 +0800
  • Message-id: <20050826104417(dot)ED62(dot)REXHSU(at)tom(dot)com>

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>


Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group