Thread: Migrating database from postgresql 7.4.6 to postgresql 8.0.3

Migrating database from postgresql 7.4.6 to postgresql 8.0.3

From
Louise Catherine
Date:
Hi,
I would like to migrating my database from postgresql
7.4.6 to postgresql 8.0.3.
Are there any problem during migrating database? a
casting problem or sintax problem, or other problem?
Can somebody help me answering this question?
Or 
Does anyone ever try to migrating database from
postgresql 7.4.6 to postgresql 8.0.3? Could you tell
me which part that change from postgresql 7.4.6 to
postgre 8.0.3? 

Thank's a lot,
Louise C.S.

    
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com


Re: Migrating database from postgresql 7.4.6 to postgresql 8.0.3

From
"A. Kretschmer"
Date:
am  08.11.2005, um 23:18:35 -0800 mailte Louise Catherine folgendes:
> Hi,
> I would like to migrating my database from postgresql
> 7.4.6 to postgresql 8.0.3.

Why not 8.1.0?


> Are there any problem during migrating database? a
> casting problem or sintax problem, or other problem?

I dont know about problems. Install the new database (on the same
machine, use a different port), and use the pg_dump from the newer
version to dump the old db in the new db.


HTH, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    === 


Re: Migrating database from postgresql 7.4.6 to postgresql

From
Achilleus Mantzios
Date:
O A. Kretschmer έγραψε στις Nov 9, 2005 :

> am  08.11.2005, um 23:18:35 -0800 mailte Louise Catherine folgendes:
> > Hi,
> > I would like to migrating my database from postgresql
> > 7.4.6 to postgresql 8.0.3.
> 
> Why not 8.1.0?
> 
> 
> > Are there any problem during migrating database? a
> > casting problem or sintax problem, or other problem?
> 
> I dont know about problems. Install the new database (on the same
> machine, use a different port), and use the pg_dump from the newer
> version to dump the old db in the new db.

Or better consult HISTORY.
It is in the root of the tarball.

> 
> 
> HTH, Andreas
> 

-- 
-Achilleus