From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | "Marcus Andree S(dot) Magalhaes" <marcus(dot)magalhaes(at)vlinfo(dot)com(dot)br> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Postgres dump & restore madness |
Date: | 2003-09-04 16:29:04 |
Message-ID: | 20030904092652.H38890-100000@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Luis Hernán Otegui | 2003-09-04 17:45:48 | unsubscribe |
Previous Message | Nabil Sayegh | 2003-09-04 16:22:40 | Re: Postgres dump & restore madness |