migrating test db -> live db

From: Steve Heaven <steve(at)thornet(dot)co(dot)uk>
To: pgsql-general(at)hub(dot)org
Subject: migrating test db -> live db
Date: 2000-09-13 10:33:04
Message-ID: 3.0.1.32.20000913113304.006fa150@mail.thornet.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We run several web based postgresql applications and find it difficult to
make changes in a safe and reliable manner.

We have test databases that mirror the live ones. When we have finished
making the testing the updated version, we labouriously go through and copy
all the changes onto the live system. Obviously the live system has to be
taken down during this.
Is is possible to do the following:

stop postmaster
copy all files from ~postgres/base/testdb/* -> ~postgres/base/livedb/*
restart postmaster

All the tables, indexes etc have the same names in both, but we may
add/alter columns for the new version.

Thanks

Steve


--
thorNET - Internet Consultancy, Services & Training
Phone: 01454 854413
Fax: 01454 854412
http://www.thornet.co.uk

Browse pgsql-general by date

  From Date Subject
Next Message Darrin Ladd 2000-09-13 13:23:44 List Problems?
Previous Message Jan Wieck 2000-09-13 07:36:16 Re: List of error messages