> -----Original Message----- > From: Renato Oliveira <renato.oliveira@xxxxxxxxxxx> > To: pgsql-admin@xxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxx> > Subject: Migrate postgres to newer hardware > Date: Tue, 30 Mar 2010 12:18:36 +0100 > > Dear All, > > > > What would be the easiest and fastest way to migrate Postgres 8.2.24 32 BIT > to a new server 64 Bit. > > > > The existing server runs on 32 bit architecture and has a database as big as > 160GB. > > > > We initially thought of using PITR, but as one of the PITR requirements is > both machines need to be similar. > > This similarity needs to be even in architecture? I think I read something > which says “Yes”. > > > > If we cannot use PITR what would be the best approach, we can’t have down > time I am afraid. > > > > Any ideas or suggestions would be very welcome. > > > > Thank you very much > > > > Best regards > > > > Renato > > > > > > > Renato Oliveira > Systems Administrator > e-mail: renato.oliveira@xxxxxxxxxxx Tel: +44 (0)1763 260811 > Fax: +44 (0)1763 262410 > www.grant.co.uk Grant Instruments (Cambridge) Ltd > > Company registered in England, registration number 658133 > > Registered office address: > 29 Station Road, > Shepreth, > CAMBS SG8 6GB > UK > > > > > P Please consider the environment before printing this email > > > CONFIDENTIALITY: The information in this e-mail and any attachments is > confidential. It is intended only for the named recipients(s). If you are > not the named recipient please notify the sender immediately and do not > disclose the contents to another person or take copies. > VIRUSES: The contents of this e-mail or attachment(s) may contain viruses > which could damage your own computer system. Whilst Grant Instruments > (Cambridge) Ltd has taken every reasonable precaution to minimise this risk, > we cannot accept liability for any damage which you sustain as a result of > software viruses. You should therefore carry out your own virus checks > before opening the attachment(s). > OpenXML: For information about the OpenXML file format in use within Grant > Instruments please visit our website > > > > > > P Please consider the environment before printing this email > > > CONFIDENTIALITY: The information in this e-mail and any attachments is > confidential. It is intended only for the named recipients(s). If you are > not the named recipient please notify the sender immediately and do not > disclose the contents to another person or take copies. > VIRUSES: The contents of this e-mail or attachment(s) may contain viruses > which could damage your own computer system. Whilst Grant Instruments > (Cambridge) Ltd has taken every reasonable precaution to minimise this risk, > we cannot accept liability for any damage which you sustain as a result of > software viruses. You should therefore carry out your own virus checks > before opening the attachment(s). > OpenXML: For information about the OpenXML file format in use within Grant > Instruments please visit our website > You can use the pg_dump method and use pgpool to replicate the new data, then when sinchronized, switch off the old node. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
