From: | "Raymond O'Donnell" <rod(at)iol(dot)ie> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Working with one live and one development database |
Date: | 2006-12-05 17:09:51 |
Message-ID: | 4575A7DF.287.8871B@rod.iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 5 Dec 2006 at 2:59, hugo(dot)wetterberg(at)gmail(dot)com wrote:
> live database. We need to copy all data, structure information,
> functions et.c. from the live database to the development database
> every now and then. The development database will be on a separate
> machine. What is the best way to do this?
I do that every now and then.....I simply do a complete dump of the
database I need using pg_dump, and then reload it on the development
machine using psql (I generally do a text-format dump).
--Ray.
----------------------------------------------------------------------
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
rod(at)iol(dot)ie
----------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2006-12-05 17:15:38 | Re: Working with one live and one development database |
Previous Message | Tom Lane | 2006-12-05 17:01:23 | Re: HELP: Urgent, Vacuum problem |