pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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






view thread (2+ messages)

Message-ID: <43F3423F.9060404@collax.com>
Permalink:  ../43F3423F.9060404@collax.com/
Also on:    postgresql.org/message-id/43F3423F.9060404@collax.com

 · 

reply

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