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: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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  :
>      BoomBox     :
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

- -- 

- --
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
Version: GnuPG v1.2.3 (GNU/Linux)


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-2017 The PostgreSQL Global Development Group