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