Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 2F6586324AF for ; Wed, 14 Jul 2010 11:46:03 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 29447-05 for ; Wed, 14 Jul 2010 14:45:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.sdb.it (mail.sdb.it [212.141.11.2]) by mail.postgresql.org (Postfix) with ESMTP id A10B1632768 for ; Wed, 14 Jul 2010 11:45:54 -0300 (ADT) Received: by mail.sdb.it (Postfix, from userid 500) id ACC23820C; Wed, 14 Jul 2010 16:45:51 +0200 (CEST) Received: from geronimo.sdb.it (geronimo.sdb.it [10.101.1.20]) by mail.sdb.it (Postfix) with ESMTP id A6BA181C1; Wed, 14 Jul 2010 16:45:51 +0200 (CEST) Received: from mailtech.sdb.it (sdbit-srv01.sdb.it [10.118.122.250]) by geronimo.sdb.it (Postfix) with ESMTP id 7F4243808AD; Wed, 14 Jul 2010 16:45:28 +0200 (CEST) Received: from [10.118.101.88] (silviob.sdb.it [10.118.101.88]) by mailtech.sdb.it (Postfix) with ESMTP id 8E2E758ABA; Wed, 14 Jul 2010 16:45:51 +0200 (CEST) Message-ID: <4C3DCD63.5040706@tech.sdb.it> Date: Wed, 14 Jul 2010 16:44:51 +0200 From: Silvio Brandani User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: Gabriele Bartolini Cc: =?UTF-8?B?ScOxaWdvIE1hcnRpbmV6IExhc2FsYQ==?= , pgsql-admin@postgresql.org Subject: Re: upgrade postgres 8.1.21 to version 8.3.6 References: <4C3C322C.4050305@tech.sdb.it> <1279054371.13317.130.camel@deimos> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Private-Material: Please read notice X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201007/66 X-Sequence-Number: 35085 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. --