Re: Migrate postgres to newer hardware - Mailing list pgsql-admin
| From | Renato Oliveira |
|---|---|
| Subject | Re: Migrate postgres to newer hardware |
| Date | |
| Msg-id | 7965A9DCF12CC14984420BCC37B1608F25ABF30D34@Elzar.grant.co.uk Whole thread Raw |
| In response to | Re: Migrate postgres to newer hardware (Iñigo Martinez Lasala <imartinez@vectorsf.com>) |
| List | pgsql-admin |
Dear all,
I would love to have things covered, but I have inherited this setup.
I am sure we will improve it, but I have to make the most with what I have got, I am afraid.
I am grateful for all the help so far, I really appreciate it.
Ps I think there should be an easier way, maybe doing as follows:
1 – Dump the database online with pg_dump, while production server is still running
2 – Restore it to the new server, while old server is still online
3 – On the old server, run a query looking for all the new transactions since the last full backup.
4 – Run a pg_dump to dump only the new transactions since last backup and restore to the new server or ‘append’ to the new server.
I think this should be possible to do.
Thank you very much for all your support and help, really appreciated.
Renato
Systems Administrator
e-mail: renato.oliveira@grant.co.uk
Company registered in England, registration number 658133
Registered office address:
29 Station Road,
Shepreth,
CAMBS SG8 6GB
UK
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Iñigo Martinez Lasala
Sent: 02 April 2010 08:41
To: Brad Nicholson
Cc: pgsql-admin
Subject: Re: [ADMIN] Migrate postgres to newer hardware
I would never sing a SLA for HA if I don't have system, at least, fully redundant in order to deal with these issues.
Single server, single point of failure.
-----Original Message-----
From: Brad Nicholson <bnichols@ca.afilias.info>
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
Cc: Renato Oliveira <renato.oliveira@grant.co.uk>, pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] Migrate postgres to newer hardware
Date: Tue, 30 Mar 2010 10:38:02 -0400
On Tue, 2010-03-30 at 16:29 +0200, Iñigo Martinez Lasala wrote:
> Hi Renato.
>
> I would follow the ancient method: perform a pg_dump / pg_restore
This is the easiest approach. The problem is that a lot of people have
contractual SLA's that do not allow them to take their systems down long
enough to do a dump and restore upgrade.
P Please consider the environment before printing this email
pgsql-admin by date: