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�mministrative 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�iuridica qualora pervengano da questo indirizzo messaggi estranei all'attivit�avorativa o contrari a norme.
--
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
