Re: Fw: postgres DB duplication

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If the test and productive machine are the same type (i.e. intel) and the
postgresql version is the same then I would try to do a filesystem copy.
Just make sure both machines have the postmaster shut down and then copy over
the /var/lib/pgsql (or wherever your system puts the stuff).

Remember: same postgres version, same architecture.

On Tuesday 27 January 2004 04: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
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

- --
UC

- --
Open Source Solutions 4U, LLC 2570 Fleetwood Drive
Phone: +1 650 872 2425 San Bruno, CA 94066
Cell: +1 650 302 2405 United States
Fax: +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAFxiQjqGXBvRToM4RApMtAJwLvFCIJUvaxUD9I3Y96dDjJAw/cwCgkV3q
UIEOokjbCwzEfRAIhBFWUhk=
=cpMy
-----END PGP SIGNATURE-----