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