| From: | Cesar Schneider <cesar(at)hzta(dot)com(dot)br> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_restore |
| Date: | 2005-01-20 05:00:25 |
| Message-ID: | 1106197225.2673.41.camel@nx9005.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers-win32 |
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(at)hzta(dot)com(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Troyston Campano | 2005-01-20 05:03:28 | Oracle and Postgresql Play Nice Together on Same Computer? |
| Previous Message | Greg Stark | 2005-01-20 04:57:12 | Re: Ways to check the status of a long-running transaction |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Niederland | 2005-01-20 08:19:36 | Re: pg_restore |
| Previous Message | Niederland | 2005-01-19 19:42:02 | Re: pg_restore |