"Niederland" <niederland@xxxxxxxxx> writes:
> System: the released Postgres 8.0, winXP
> Using:
> pg_dump --format=t --blobs myDB > DBFile
> pg_restore --create -dbname=crm DBFile
> Resulted in:
> pg_restore: [archiver] unsupported version (1.13) in file header
Come to think of it, I'll bet that you cannot use "> DBFile" on Windows
because it ends up opening the archive file in text instead of binary
mode. SetOutput() in pg_backup_archiver.c tries to work around this by
doing
fn = fileno(stdout);
AH->OF = fdopen(dup(fn), PG_BINARY_W);
but it wouldn't surprise me in the least to learn that that doesn't work
on Windows.
Does it work if you use
pg_dump --format=t --blobs -f DBFile myDB
? Can anyone on pgsql-hackers-win32 think of a way around this?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
