X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2819A9DCBE4 for ; Wed, 15 Feb 2006 11:08:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 42424-04 for ; Wed, 15 Feb 2006 11:08:55 -0400 (AST) X-Greylist: delayed 00:11:15.238103 by SQLgrey- Received: from mail.collax.com (mail.collax.com [213.164.67.137]) by postgresql.org (Postfix) with ESMTP id 0B3539DCB8F for ; Wed, 15 Feb 2006 11:08:45 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by localhost (Postfix) with ESMTP id 9E268298002 for ; Wed, 15 Feb 2006 16:08:50 +0100 (CET) Received: from mail.collax.com (localhost [127.0.0.1]) by localhost (AvMailGate-2.0.3-24) id 17176-489132E7; Wed, 15 Feb 2006 16:08:50 +0100 Received: from [172.16.1.21] (unknown [172.16.1.21]) by mail.collax.com (Postfix) with ESMTP id 4C25A298002 for ; Wed, 15 Feb 2006 16:08:50 +0100 (CET) Message-ID: <43F3423F.9060404@collax.com> Date: Wed, 15 Feb 2006 16:01:19 +0100 From: Tilman Baumann User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051017) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 CC: pgsql-admin@postgresql.org Subject: Re: making duplicate of database for development References: <43F33F99.8050409@collax.com> In-Reply-To: <43F33F99.8050409@collax.com> Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: quoted-printable X-Filtered: By ProxSMTP X-AntiVirus: checked by AntiVir MailGate (version: 2.0.3-24; AVE: 6.33.0.31; VDF: 6.33.0.239; host: mail) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.214 required=5 tests=[AWL=0.025, MISSING_HEADERS=0.189] X-Spam-Score: 0.214 X-Spam-Level: X-Archive-Number: 200602/190 X-Sequence-Number: 20611 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. > > =20 > --=20 Tilman Baumann Software Developer Collax GmbH . Boetzinger Stra=DFe 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