Re: Fw: postgres DB duplication

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
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~