On Tue, 20 Apr 2004, Bruno Wolff III wrote: > On Tue, Apr 20, 2004 at 14:36:57 +0100, > csysi <[EMAIL PROTECTED]> wrote: > > Hello, i upgrade postgres version 7.1 to version 7.4.2 and it tell me that > > the databases are incompatible. > > > > Can i convert the databases ? > > You need to do a dump and reload to go between major releases (e.g. > from 7.1.x to 7.2.x). If you overlaid your 7.1 binaries you are going > to have to uninstall 7.4 and reinstall 7.1 and dump the database. > If you have the 7.1 binaries and the 7.4 binaries available, you > should use the 7.4 pg_dump(all) to do the dump as it is better > about handling dependencies and some other things.
Bruno, a ton of work went into making the pg_dump in 7.4 capable of dumping the older versions back through, I believe 7.0 or 6.5 or so. Basically, the recommended method now is to just use 7.4's dump of a running 7.1 database to get the dump. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
