| From: | Tilman Baumann <tilman(dot)baumann(at)collax(dot)com> |
|---|---|
| To: | |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: making duplicate of database for development |
| Date: | 2006-02-15 15:01:19 |
| Message-ID: | 43F3423F.9060404@collax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2006-02-15 21:20:15 | Re: constraint_exclusion on OLTP tables |
| Previous Message | Tilman Baumann | 2006-02-15 14:50:01 | making duplicate of database for development |