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-
(BHash: SHA1
(B
(B
(BIf the test and productive machine are the same type (i.e. intel) and the
(Bpostgresql version is the same then I would try to do a filesystem copy.
(BJust make sure both machines have the postmaster shut down and then copy over
(Bthe
(B
(B
(BHi
(BI've built up 30 gig database on a performance test
(Bmachine which
(Bnow needs to be transferred over onto the
(Bproduction hardware
(Bwhich will be going live.
(BThe documentation suggests using pg_dump or a file
(Bsystem level backup
(B - does anyone have any experien
