CPU move - Mailing list pgsql-general

From Carlos Henrique Reimer
Subject CPU move
Date
Msg-id CAJnnue076FgFuh_dUR7v=pN=jXH2S0R6pSPTTWgm1w4JRtdSQw@mail.gmail.com
Whole thread Raw
Responses Re: CPU move  (Alan Hodgson <ahodgson@simkin.ca>)
Re: CPU move  (Frank Lanitz <frank@frank.uvena.de>)
List pgsql-general
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.

Checked the locale files and they were not customized and are the same in the same box.

Which risks am I exposed in this approach?

Thank you!

--
Reimer
47-3347-1724 47-9183-0547 msn: carlos.reimer@opendb.com.br

pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: General performance/load issue
Next
From: Alan Hodgson
Date:
Subject: Re: CPU move