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 looooooong time.
On Jan 27, 2004, at 7:36 PM, Colm De Barra wrote:
--------------------Hi I've built up 30 gig database on a performance test machine which now needs to be transferred over onto the production hardware which will be going live. The documentation suggests using pg_dump or a file system level backup - does anyone have any experience of using these on large DBs ? Any tips or advice before I take the plunge ?? Cheers Colm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ My Website :http://www.angelfire.com/ia/japan/ BoomBox :http://www.b00mb0x.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
