From: | "Niederland" <niederland(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_restore |
Date: | 2005-01-19 19:42:02 |
Message-ID: | 1106163722.780395.266900@z14g2000cwz.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers-win32 |
I am having the same problem:
System: the released Postgres 8.0, winXP
Install performed an initDB. Tryed all types of backup/restore
combinations, see below:
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
NOTE: File was created from pg_dump
and then tried as an input to pg_restore. File was not viewed or
modified
in any way.
*************
Using:
pg_dump --format=t --blobs myDB > DBFile
Resulted in:
pg_dump: [custom archiver] WARNING: ftell mismatch with expected
position -- ftell used
************
Using:
pg_dump --format=t --blobs myDB > DBFile
Resulted in:
pg_dump: large-object output is not supported for plain-text dump files
pg_dump: <Use a different output format.>
***********
Tom Lane wrote:
> Cesar Schneider <cesar(at)hzta(dot)com(dot)br> writes:
> > When I execute pg_restore I get this error:
> > pg_restore: [archiver] unsupported version (1.13) in file header
>
> There is no 1.13; you have a corrupt dump file. Personally I'd bet
> money that you ran it through a Windows newline conversion (LF to
CR/LF).
>
> regards, tom lane
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Lavoie | 2005-01-19 20:06:21 | Debian Sarge, Postgres 7.4.6 + PAM |
Previous Message | Devrim GUNDUZ | 2005-01-19 19:39:23 | Re: Best Linux Distribution |
From | Date | Subject | |
---|---|---|---|
Next Message | Cesar Schneider | 2005-01-20 05:00:25 | Re: pg_restore |
Previous Message | Tom Lane | 2005-01-17 20:23:45 | Re: pg_restore |