moving from 7.4.13 to 8.0.14

Hi,

Currently I am using postgres 7.4.13 and I will like upgrade it to 8.0.14
I have backup my databases by using pg_dumpall (7.4.13)
pg_dumpall -U postgres > /root/backup_all_db

Is it doable to load the backup file using the psql (8.0.14) ?

Another question: Is it possible to upgrade 7.4.13 straight to 8.2?




Many Thanks,
Antonis





--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: moving from 7.4.13 to 8.0.14

On Thu, Apr 24, 2008 at 4:15 AM, Antonis Antoniou
wrote:
> Hi,
>
> Currently I am using postgres 7.4.13 and I will like upgrade it to 8.0.14
> I have backup my databases by using pg_dumpall (7.4.13)
> pg_dumpall -U postgres > /root/backup_all_db

It will probably work. However, it is best to dump the old database
(7.4.x) with the new pg_dump (8.0.x)

> Is it doable to load the backup file using the psql (8.0.14) ?

Yes. psql is the preferred restore program for uncompressed file formats.

> Another question: Is it possible to upgrade 7.4.13 straight to 8.2?

yes, and also 8.3 as well. I'd recommend going to at least 8.2. 8.3
got rid of a lot of auto-type coercion that may break some poorly
formed queries. I'd recommend at least testing on 8.3 to see if you
can go to it.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin