I am trying to restore a dump (custom archive format) using pg_restore like this:
type C:\testdump | pg_restore -Fc -C -U postgres -w -d postgres
where testdump contains the database dump from the following commmand:
pg_dump -U postgres -Fc test > C:\testdump
the restore command fails :
C:\Program Files (x86)\PostgreSQL\8.4\bin>type C:\testdump | pg_restore -Fc -C -v -U postgres -w -d postgres
pg_restore: connecting to database for restore
pg_restore: creating DATABASE test
pg_restore: connecting to new database "test"
pg_restore: connecting to database "test" as user "postgres"
pg_restore: creating SCHEMA public
pg_restore: creating COMMENT SCHEMA public
pg_restore: creating PROCEDURAL LANGUAGE plpgsql
pg_restore: creating TABLE tb1
pg_restore: restoring data for table "tb1"
pg_restore: [custom archiver] could not find block ID 1770 in archive -- possibly corrupt archive
pg_restore: *** aborted because of error
I have read about Custom format behavior that restore involves going back & front inside the dump for the entire database restore.
But the same redirection works in Unix very well.
cat /test/dump > pg_restore -Fc -C -U postgres -w -d postgres
completely the restore correctly.
The dump header is :
;
; Archive created at Tue Mar 29 10:36:58 2011
; dbname: test
; TOC Entries: 9
; Compression: -1
; Dump Version: 1.11-0
; Format: CUSTOM
; Integer: 4 bytes
; Offset: 8 bytes
; Dumped from database version: 8.4.7
; Dumped by pg_dump version: 8.4.7
;
;
; Selected TOC Entries:
;
1771; 0 0 ENCODING - ENCODING
1772; 0 0 STDSTRINGS - STDSTRINGS
1773; 1262 16395 DATABASE - test postgres
3; 2615 2200 SCHEMA - public postgres
1774; 0 0 COMMENT - SCHEMA public postgres
; depends on: 3
1775; 0 0 ACL - public postgres
; depends on: 3
304; 2612 16386 PROCEDURAL LANGUAGE - plpgsql postgres
1491; 1259 16396 TABLE public tb1 postgres
; depends on: 1769 3
1770; 0 16396 TABLE DATA public tb1 postgres
; depends on: 1491
One might want to ask why do you want to use type OR cat commands when you have a dump file already, but this dump file comes in a buffer stream which i will read and apply to pg_restore using pipes both in Unix & Windows. For the test purpose i have write the stream into file and trying restore.
can someone help me achieve this?
--
Ravi Thati
Continuous Efforts with Infinite Faith is evident in all success stories.
