Cheer,
If you want to make a cold backup, be carreful if you have distributed
your database on different disks with symbolic links or by using the initloaction
command as a tar or cpio won't save the symbolic tree . Otherwise you can
save all your $PGDATA directory and copy it on your new machin
A file system mirror (provided its the same type of system) will be
much easier. Just shut down postgres
on the test machine and rsync away. Dump and restore on something that
size will take a looong time.
On Jan 27, 2004, at 7:36 PM, Colm De Barra wrote:
Hi
I've built up 30 gig database on
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
If the test and productive machine are the same type (i.e. intel) and the
postgresql version is the same then I would try to do a filesystem copy.
Just make sure both machines have the postmaster shut down and then copy over
the
