Обсуждение: update to 8.3.3

Поиск
Список
Период
Сортировка

update to 8.3.3

От
Jumping
Дата:
Hi,all!
    I plan to update my database from 8.1.9 to 8.3.3.
    Is there any tricks or tips ?
    Thanks in advance.

--
Don't tell me how many the enemies,but where they are!
(ADV:Perl -- It's like Java, only it lets you deliver on time and under budget.)

Re: update to 8.3.3

От
Devrim GÜNDÜZ
Дата:
On Mon, 2008-09-08 at 11:35 +0800, Jumping wrote:
>     I plan to update my database from 8.1.9 to 8.3.3.
>     Is there any tricks or tips ?

I would first update to 8.1.13, then go on.

Anysay, Read the release notes, and check for any possible
incompatibility issues.

http://www.postgresql.org/docs/current/static/release-8-3.html
http://www.postgresql.org/docs/current/static/release-8-2.html

I believe you should first check the casting changes in 8.3 .

Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
                   http://www.gunduz.org

Вложения

Re: update to 8.3.3

От
Achilleas Mantzios
Дата:
Στις Monday 08 September 2008 16:14:29 ο/η Devrim GÜNDÜZ έγραψε:
> On Mon, 2008-09-08 at 11:35 +0800, Jumping wrote:
> >     I plan to update my database from 8.1.9 to 8.3.3.
> >     Is there any tricks or tips ?
>
> I would first update to 8.1.13, then go on.

Hehe i upgraded from 7.4 to 8.3.3 and it was a big pain,
but since i survived i'd say 8.1.9->8.3.3 is at least safe!
It all depends on the quality (standard-wise) of the original SQL code however.

>
> Anysay, Read the release notes, and check for any possible
> incompatibility issues.
>
> http://www.postgresql.org/docs/current/static/release-8-3.html
> http://www.postgresql.org/docs/current/static/release-8-2.html
>
> I believe you should first check the casting changes in 8.3 .
>
> Regards,



--
Achilleas Mantzios