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