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
