|
I would guess
that you need to do the pg_dump on the old machine, tranfser the file to the
destination machine, open a psql window on the destination machine and then run
the command to restore the database on that destination
machine.
The command
listed below might work if you were going from 7.4.x to 7.4.x
I'm trying to do pg_dump an old version (7.3.4) to a new one (7.4.1) with the
following command:
pg_dump -U username -h server -i -o database | psql -U
username -h newserver newdatabase
As a result I got:
pg_dump: server
version:PostgreSQL 7.3.4 on i586-pc-linux-gnu, compiled by GCC
2.95.3;
pg_dump version:7.2
pg_dump: proceeding despite
version mismatch
pg_dump: query to
obtain list of data types failed
error: attribute
"typprtlen" not found"
What is this attribute?
Am I doing something wrong?
Is there any better way to dump the
database to another version?
Any help will be welcome
Many
thanks
Paulo
Zimolo
|
<<attachment: Notebook.jpg>>
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
