[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

inapropriated postgres package pre-install script?



Hello,

it now the third machine where i have to do the manipulation by hand, and when
forgotten it is realy a pain....

each time i launch a dselect there's the horror of the possibility of an
upgrade of the postgres DB.... often on launching the upgrade the thought
comes arghhhh did i do a backup of the base??? because if not i found no way
to recover the base again....

why does the pre install script hasn't  the simple line pg_dumpall >backup and
the post install the line psql -e template1<backup????? 

it would prevent stupid users like me to have disastrous updates and lots of
nightmares trying to recover lost databases..... BTW is there any way (except
using cp and vi) to recover a database across postgres versions? The way
described in the HOWTO ends each time with the message the postmaster isn't
started, which is a cat biting in its tail, since the postmaster couldn't be
started due to obsolete base....

-- 
ciao bboett
==============================================================
bboett@earthling.net
http://inforezo.u-strasbg.fr/~bboett http://erm1.u-strasbg.fr/~bboett
===============================================================
the total amount of intelligence on earth is constant.
human population is growing....


Reply to: