Re: pg_restore - Mailing list pgsql-general

From Cesar Schneider
Subject Re: pg_restore
Date
Msg-id 1106197225.2673.41.camel@nx9005.localdomain
Whole thread Raw
In response to pg_restore  (Cesar Schneider <cesar@hzta.com.br>)
List pgsql-general
I'm still having problems to restore a database.

The dump command used was:

# pg_dump -Ft -b -o database > database.dump

This dump was created in Postgres 8.0beta5 (Windows).

When I try to restore this file in Postgres 8.0-rc3 (Linux) I get this
error:

# pg_restore -Ft -d database database.dump

Using a dump file generated in pgadmin3, works fine... but pgadmin
exports some strange things that are not related to the database.

What can be wrong ?

Cesar


On Mon, 2005-01-17 at 18:42, Tom Lane wrote:
> Cesar Schneider <cesar@hzta.com.br> writes:
> > but is not a plain text dump, so I don't think that is a CRFL problem.
>
> Exactly, but you did something to it with a program that thought it was
> plain text.  The actual current version number is 1.10.  I think it is
> pretty suggestive that LF == 10 decimal and CR == 13 decimal.
>
>             regards, tom lane
>


pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Ways to check the status of a long-running transaction
Next
From: "Troyston Campano"
Date:
Subject: Oracle and Postgresql Play Nice Together on Same Computer?