Working with one live and one development database

From: hugo(dot)wetterberg(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Working with one live and one development database
Date: 2006-12-05 10:59:06
Message-ID: 1165316346.506102.184460@j72g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
We are moving from MySQL to PgSQL in my organization and I would like
some input on what the best method is for working with one development
and one live database. We need to copy all data, structure information,
functions et.c. from the live database to the development database
every now and then. The development database will be on a separate
machine. What is the best way to do this?

Kind regards
Hugo Wetterberg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Faqeer ALI 2006-12-05 11:21:58 iplike.so access denied help!!
Previous Message Bernd Helmle 2006-12-05 10:57:39 Re: How to speed up Exclusive Locking