|
|
 | | From: | Marcin Gil | | Subject: | 7.4.x to 8.0 upgrade process | | Date: | Thu, 20 Jan 2005 08:35:34 +0100 |
|
|
 | 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
|
|
| | From: | Sean Davis | | Subject: | Re: 7.4.x to 8.0 upgrade process | | Date: | Thu, 20 Jan 2005 08:21:01 -0500 |
|
|
|
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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
|
|
| | From: | Marcin Gil | | Subject: | Re: 7.4.x to 8.0 upgrade process | | Date: | Thu, 20 Jan 2005 16:22:08 +0100 |
|
|
| ----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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
|
|
| | From: | Sean Davis | | Subject: | Re: 7.4.x to 8.0 upgrade process | | Date: | Thu, 20 Jan 2005 10:31:54 -0500 |
|
|
|
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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
|
|
|
