Обсуждение: making duplicate of database for development

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

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