| From: | Frank Lanitz <frank(at)frank(dot)uvena(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: CPU move |
| Date: | 2011-11-27 09:59:13 |
| Message-ID: | 4ED209F1.9090107@frank.uvena.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am 26.11.2011 19:18, schrieb Carlos Henrique Reimer:
> Hi,
>
> We're planning to move our postgreSQL database from one CPU box to
> another box.
>
> I'm considering an alternative procedure for the move as the standard
> one (pg_dump from the old, copy dump to the new box, psql to restore in
> the new) will take about 10 hours to complete. The ideia is installing
> the same Linux and PostgreSQL versions in the new box and copy the
> entire database cluster directory from the old to the new one using the
> scp Linux command.
If you are using the same architecture you could use the warm-standby
procedure for doing the sync and then switching the system. There is
pg_standby available for.
Cheers,
Frank
| From | Date | Subject | |
|---|---|---|---|
| Next Message | frank | 2011-11-27 10:17:12 | Re: CPU move |
| Previous Message | Gaëtan Allart | 2011-11-27 09:45:50 | Re: General performance/load issue |