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 4528F9DCBAF for ; Wed, 15 Feb 2006 10:57:35 -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 35717-10 for ; Wed, 15 Feb 2006 10:57:39 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 2F7989DCB8F for ; Wed, 15 Feb 2006 10:57:33 -0400 (AST) Received: from mail.collax.com (mail.collax.com [213.164.67.137]) by svr4.postgresql.org (Postfix) with ESMTP id 50D955AF09C for ; Wed, 15 Feb 2006 14:57:38 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by localhost (Postfix) with ESMTP id C6511298002 for ; Wed, 15 Feb 2006 15:57:32 +0100 (CET) Received: from mail.collax.com (localhost [127.0.0.1]) by localhost (AvMailGate-2.0.3-24) id 15691-3ED6ECAC; Wed, 15 Feb 2006 15:57:32 +0100 Received: from [172.16.1.21] (unknown [172.16.1.21]) by mail.collax.com (Postfix) with ESMTP id 6140F298002 for ; Wed, 15 Feb 2006 15:57:32 +0100 (CET) Message-ID: <43F33F99.8050409@collax.com> Date: Wed, 15 Feb 2006 15:50:01 +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 To: pgsql-admin@postgresql.org Subject: making duplicate of database for development 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 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/189 X-Sequence-Number: 20610 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 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