From: | Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it> |
---|---|
To: | Gabriele Bartolini <Gabriele(dot)Bartolini(at)2ndQuadrant(dot)it> |
Cc: | Iñigo Martinez Lasala <imartinez(at)vectorsf(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: upgrade postgres 8.1.21 to version 8.3.6 |
Date: | 2010-07-14 14:44:51 |
Message-ID: | 4C3DCD63.5040706@tech.sdb.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Gabriele Bartolini ha scritto:
> Ciao Silvio,
>
> On Tue, 13 Jul 2010 22:52:51 +0200, Iñigo Martinez Lasala
>
>> You should script database migration process in order to make it faster.
>> Upgrading binaries is really simple. A yum upgrade should be enough.
>>
>
> Yes, faster and repeatable. Something you can launch with a script that
> does everything from scratch. As Iñigo was pointing out, you must pay a lot
> of attention in setting up a test environment which helps you:
>
> * simulate the migration process (and gives you accurate measures of
> times)
> * test the applications
>
> As Iñigo said, on a typical usage pattern, the most likely set of errors
> you will encounter are data type checks which require casting. Therefore it
> becomes crucial to:
>
> * setup the test database (preferably on a different server)
> * setup test applications that interface with the new Postgres database
>
> I assume you are using 8.3 because of RPM availability, isn't it?
> Otherwise, you should think of 8.4.
>
> Ciao,
> Gabriele
>
>
I have simulate the upgrade process in a test environment -
The casting problem in effect occurs, we will provide the required
modification at application code before proceeding with the upgrade.
thanks a lot -
Regards,
--
---
Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalit amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelbene.com/news/privacy.html
Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/codice_penale_616.html
L'Azienda non si assume alcuna responsabilit giuridica qualora pervengano da questo indirizzo messaggi estranei all'attivit lavorativa o contrari a norme.
--
From | Date | Subject | |
---|---|---|---|
Next Message | Burgholzer, Robert (DEQ) | 2010-07-14 16:33:10 | proper tuning for restoring from pg_dump in 8.3.7 |
Previous Message | Eduardo Sá dos Reis | 2010-07-14 13:48:16 | Error after upgrade 8.1.4 to 8.4.2 |