Re: [ADMIN] making duplicate of database for development

2006-02-15 Thread Tilman Baumann
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 fo

[ADMIN] making duplicate of database for development

2006-02-15 Thread Tilman Baumann
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 c