pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmaking duplicate of database for development
2+ messages / 1 participants
[nested] [flat]
* making duplicate of database for development
@ 2006-02-15 14:50 Tilman Baumann <tilman.baumann@collax.com>
2006-02-15 15:01 ` Re: making duplicate of database for development Tilman Baumann <tilman.baumann@collax.com>
0 siblings, 1 reply; 2+ messages in thread
From: Tilman Baumann @ 2006-02-15 14:50 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: making duplicate of database for development
2006-02-15 14:50 making duplicate of database for development Tilman Baumann <tilman.baumann@collax.com>
@ 2006-02-15 15:01 ` Tilman Baumann <tilman.baumann@collax.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tilman Baumann @ 2006-02-15 15:01 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-02-15 15:01 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-15 14:50 making duplicate of database for development Tilman Baumann <tilman.baumann@collax.com>
2006-02-15 15:01 ` Tilman Baumann <tilman.baumann@collax.com>
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