Postgres dump & restore madness

From: "Marcus Andree S(dot) Magalhaes" <marcus(dot)magalhaes(at)vlinfo(dot)com(dot)br>
To: pgsql-novice(at)postgresql(dot)org
Subject: Postgres dump & restore madness
Date: 2003-09-04 16:12:57
Message-ID: 1062691977.3f576489f2d14@webmail.vlinfo.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello, all.

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.

All tables and the database itself were created OK (except by the lack
of constraints) but they weren't populated (certainly the number of
SQL syntax errors can explain this very well).

So, here go my questions (please forgive my dumbness) :

1 - How can a postgresql database be safely restored with all constraints, views,
functions and other non-data related information?

2 - When I dump a db into SQL commands, they are supposed to be more or less
portable, aren't they?

3 - Can anyone provide some ideas about how can I make this process work? I'm
really begining to become frustrated about this.

Any help is welcome.

Thanks indeed.

marcus.

-------------------------------
http://www.vlinfo.com.br

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-09-04 16:22:40 Re: Postgres dump & restore madness
Previous Message Ron Johnson 2003-09-04 09:12:56 Re: Powergres (was Re: Errors on restoring a 7.1.2 dump