Обсуждение: 7.4.x to 8.0 upgrade process
Ok. Just make sure: a) pg_dump all databases using pg_dump from version 7.4.x I have to use pg_dump and not pg_dumpall since I have to dump tables with OID order and large objects into binary formats. b) stop postgres and backup all files in case of emergency c) remove/install or upgrade to version 8.0 d) pg_restore all databases Is that correct? Kind regards, -Marcin Gil -- OIS "Audax" Sp. z o.o., Tomaszow Mazowiecki, ul. Barlickiego 4 tel. (+48 44) 7247530 ext. 22, fax. (+48 44) 7247530 ext. 25, mobile +48 509229662
On Jan 20, 2005, at 2:35 AM, Marcin Gil wrote: > Ok. Just make sure: > > a) pg_dump all databases using pg_dump from version 7.4.x > I have to use pg_dump and not pg_dumpall since I have to dump tables > with OID order and large objects into binary formats. > My understanding from reading the 8.0.0 INSTALL docs is that it is best to use the pg_dumpall from 8.0.0 rather than 7.4.x. Sean
----Original Message---- From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Sean Davis Sent: Thursday, January 20, 2005 2:21 PM To: Marcin Gil Cc: pgsql-novice@postgresql.org Subject: Re: [NOVICE] 7.4.x to 8.0 upgrade process > On Jan 20, 2005, at 2:35 AM, Marcin Gil wrote: > >> Ok. Just make sure: >> >> a) pg_dump all databases using pg_dump from version 7.4.x >> I have to use pg_dump and not pg_dumpall since I have to dump >> tables with OID order and large objects into binary formats. >> > > My understanding from reading the 8.0.0 INSTALL docs is that > it is best to use the pg_dumpall from 8.0.0 rather than 7.4.x. > That's mine too but... How can I install 8.0 simultaneously with 7.4.x? 7.4.x has to be running databases while 8.0 should dump them. Running 8.0 with 7.4.x files is "A Bad Idea" I heard :) -Marcin -- OIS "Audax" Sp. z o.o., Tomaszow Mazowiecki, ul. Barlickiego 4 tel. (+48 44) 7247530 ext. 22, fax. (+48 44) 7247530 ext. 25, mobile +48 509229662
On Jan 20, 2005, at 10:22 AM, Marcin Gil wrote: > ----Original Message---- > From: pgsql-novice-owner@postgresql.org > [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Sean Davis > Sent: Thursday, January 20, 2005 2:21 PM > To: Marcin Gil > Cc: pgsql-novice@postgresql.org > Subject: Re: [NOVICE] 7.4.x to 8.0 upgrade process > >> On Jan 20, 2005, at 2:35 AM, Marcin Gil wrote: >> >>> Ok. Just make sure: >>> >>> a) pg_dump all databases using pg_dump from version 7.4.x >>> I have to use pg_dump and not pg_dumpall since I have to dump >>> tables with OID order and large objects into binary formats. >>> >> >> My understanding from reading the 8.0.0 INSTALL docs is that >> it is best to use the pg_dumpall from 8.0.0 rather than 7.4.x. >> > That's mine too but... How can I install 8.0 simultaneously with 7.4.x? > 7.4.x has to be running databases while 8.0 should dump them. > Running 8.0 with 7.4.x files is "A Bad Idea" I heard :) > I did: stop the postmaster (7.4.x) mv /usr/local/pgsql /usr/local/pgsql7.4.x install pg 8.0.0 as usual restart postmaster with -D /usr/local/pgsql7.4.x/data pg_dumpall > db.out #if your path is set as before and 8.0.0 is installed in /usr/local/pgsql, pg_dumpall is now the 8.0.0 version stop the postmaster with -D /usr/local/pgsql7.4.x/data start the postmaster with -D /usr/local/pgsql/data restore the database as usual. This worked for me. Sean