Re: [GENERAL] upgrade postgres 7.1 to 7.4.2
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
Re: [GENERAL] upgrade postgres 7.1 to 7.4.2
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. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] upgrade postgres 7.1 to 7.4.2
Quoting csysi <[EMAIL PROTECTED]>: > 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 ? > > > Thank´s for the help > > > Jorge > > > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > If you could post the exact error that you are getting and how you are proceeding that would be helpful. However, I've upgraded 7.1.3 to 7.4 and I had lots of problems until I used the pg_dumpall from 7.4. In my case, it had two boxes so I ran the pg_dump from the 7.4 box to the 7.1.3. Basically, you are dumping over the network. Its very straight forward. All you have to do is set up the appropriate parameters in the pg_hba.conf file of your 7.1 box and follow the directions in the man page of pg_dumpall (see the "-h" parameter). If you are not on a network, you could install 7.4 version in a different directory and configure to run on a different port. You still dump via IP this way. You can run both systems head to head that way and see how things went. Good luck- -- Keith C. Perry, MS E.E. Director of Networks & Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[GENERAL] upgrade postgres 7.1 to 7.4.2
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 ? Thank´s for the help Jorge ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
