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 machine.
One more thing. If the Postgres version is not the same between your development machine and your exploitation machine (for exemple 7.3.3 and 7.4.1), you have to use pg_dump / pg_restore, as the data structure have changed between the 2 releases.
About the time. For a 17 Gb database on a 4 disks RAID0 LUN with PG 7.4, pg_dump takes about 17 min and pg_restore takes about 67 min.
I hope that these info will help you.
Thierry Missimilly
Colm De Barra wrote:
HiI've built up 30 gig database on a performance test machine whichnow needs to be transferred over onto the production hardwarewhich 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 ?? CheersColm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
My Website : http://www.angelfire.com/ia/japan/
BoomBox : http://www.b00mb0x.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~