Skip site navigation (1) Skip section navigation (2)

Re: Fw: postgres DB duplication

From: "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>
To: "Colm De Barra" <colm(at)aruke(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Fw: postgres DB duplication
Date: 2004-01-28 02:04:00
Message-ID: 200401271804.00989.uwe@oss4u.com (view raw or flat)
Thread:
Lists: pgsql-general
-----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-----


In response to

pgsql-general by date

Next:From: Andrew RawnsleyDate: 2004-01-28 02:09:01
Subject: Re: Fw: postgres DB duplication
Previous:From: Alvaro HerreraDate: 2004-01-28 01:51:36
Subject: Re: Permission Problems:-)?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group