| 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: | Whole Thread | Raw Message | 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 |