From: Tilman Baumann <tilman.baumann@collax.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: making duplicate of database for development
Date: Wed, 15 Feb 2006 16:01:19 +0100
Message-ID: <43F3423F.9060404@collax.com> (raw)
In-Reply-To: <43F33F99.8050409@collax.com>
References: <43F33F99.8050409@collax.com>
I made a dump with pg_dump -s -Fp --no-owner and removed the database
and schema definition ontop of the dump. Then i imported it into my new
database.
Seems to work.
Is this how you do it? :)
Tilman Baumann schrieb:
>hi.
>
>I like to make a copy of my existing database as a playgound/sandbox for
>developing.
>
>Is there any advise ho to achive this?
>
>Maybe there are tips how to work with it. Recommended workflows for
>taking a snapsot of one database and transfer it to another (including
>schema) and backmerging the changes on the developmnt playground.
>
>Thank you.
>
>
>
--
Tilman Baumann
Software Developer
Collax GmbH . Boetzinger Straße 60 . 79111 Freiburg . Germany
p: +49 (0) 761-4514-836
f: +49 (0) 761-4563-793
****** Meet us at CeBIT ******
LinuxPark, Halle 5, Stand E64/6
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tilman.baumann@collax.com
Subject: Re: making duplicate of database for development
In-Reply-To: <43F3423F.9060404@collax.com>
References: <43F33F99.8050409@collax.com> <43F3423F.9060404@collax.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox