Dumping from version 7.3.4 to 7.4.1

From: "Paulo Rogerio Zimolo" <paulorz(at)grieg(dot)com(dot)br>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Dumping from version 7.3.4 to 7.4.1
Date: 2004-02-11 12:28:29
Message-ID: MKEKLDODNBMBDBCIMKMOIEMBDGAA.paulorz@grieg.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Creager 2004-02-11 13:01:04 Re: Log query results?
Previous Message Peter Galbavy 2004-02-11 08:32:52 Re: hanging for 30sec when checkpointing