Re: pg_restore

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

In response to

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers-win32 by date

  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