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 === ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match