Re: Postgres dump & restore madness - Mailing list pgsql-novice

From Stephan Szabo
Subject Re: Postgres dump & restore madness
Date
Msg-id 20030904092652.H38890-100000@megazone.bigpanda.com
Whole thread Raw
In response to Postgres dump & restore madness  ("Marcus Andree S. Magalhaes" <marcus.magalhaes@vlinfo.com.br>)
List pgsql-novice
On Thu, 4 Sep 2003, Marcus Andree S. Magalhaes wrote:

> I need to transfer a database from postgres 7.3.3 to another server, managed
> by other people, running version 7.2.3.
>
> So, I've pg_dump'ed the db with SQL output.
>
> While visually inspecting the file, I've noticed that were no reference
> to table constraints, like foreign keys. Going on with the process, I've
> tried to restore the database using psql -f <filename> and it generated
> tons of errors (one error per SQL command, I guess) related to SQL syntax.

Can you give some examples of the lines that errored and what the errors
were to help us narrow it down a bit.



pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: Postgres dump & restore madness
Next
From: Luis Hernán Otegui
Date:
Subject: unsubscribe