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
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 |