pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Dumping from version 7.3.4  to 7.4.1
3+ messages / 3 participants
[nested] [flat]

* Dumping from version 7.3.4  to 7.4.1
@ 2004-02-11 12:28  Paulo Rogerio Zimolo <paulorz@grieg.com.br>
  0 siblings, 1 reply; 3+ messages in thread

From: Paulo Rogerio Zimolo @ 2004-02-11 12:28 UTC (permalink / raw)
  To: 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

Attachments:

Notebook.jpg (image/jpeg, 2.9K) download view image
^ permalink raw reply [nested|flat] 3+ messages in thread

* Re: Dumping from version 7.3.4  to 7.4.1
@ 2004-02-12 22:42  Stephan Szabo <sszabo@megazone.bigpanda.com>
  parent: Paulo Rogerio Zimolo <paulorz@grieg.com.br>
  0 siblings, 0 replies; 3+ messages in thread

From: Stephan Szabo @ 2004-02-12 22:42 UTC (permalink / raw)
  To: Paulo Rogerio Zimolo <paulorz@grieg.com.br>; +Cc: pgsql-admin


On Wed, 11 Feb 2004, Paulo Rogerio Zimolo wrote:

> 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

It looks to me like the pg_dump you're using is even further out of date
by the above.  I'd suggest trying to use the 7.4.1 pg_dump if you've got
it or at least the 7.3.4 one failing that.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Dumping from version 7.3.4  to 7.4.1
@ 2004-02-12 22:54  Godshall Michael <Michael_Godshall@gmachs.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Godshall Michael @ 2004-02-12 22:54 UTC (permalink / raw)
  To: 'paulorz@grieg.com.br' <paulorz@grieg.com.br>; pgsql-admin

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 
 
 

-----Original Message-----
From: Paulo Rogerio Zimolo [mailto:paulorz@grieg.com.br]
Sent: Wednesday, February 11, 2004 6:28 AM
To: pgsql-admin@postgresql.org
Subject: Dumping from version 7.3.4 to 7.4.1


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


 

Attachments:

Notebook.jpg (image/jpeg, 2.9K) download view image
^ permalink raw reply [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-02-12 22:54 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-11 12:28 Dumping from version 7.3.4  to 7.4.1 Paulo Rogerio Zimolo <paulorz@grieg.com.br>
2004-02-12 22:42 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
2004-02-12 22:54 Re: Dumping from version 7.3.4  to 7.4.1 Godshall Michael <Michael_Godshall@gmachs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox