Re: Dumping from version 7.3.4 to 7.4.1
| От | Godshall Michael |
|---|---|
| Тема | Re: Dumping from version 7.3.4 to 7.4.1 |
| Дата | |
| Msg-id | A596FA3368757645AF862C701495CA0002A5E683@hor1mspmx01.gmachs.com обсуждение исходный текст |
| Ответ на | Dumping from version 7.3.4 to 7.4.1 ("Paulo Rogerio Zimolo" <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.1I'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 newdatabaseAs 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.2pg_dump: proceeding despite version mismatchpg_dump: query to obtain list of data types failederror: 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 welcomeMany thanksPaulo Zimolo
Вложения
В списке pgsql-admin по дате отправления: