> We've had a couple of cases recently where we had to advise > DBAs to make manual changes in the system catalogs --- see > for instance the 7.4.2 release notes or > http://archives.postgresql.org/pgsql-announce/2005-05/msg00001.php > > It'd be nicer if this sort of thing could be handled > automatically by a software update. There are good reasons > why it's not trivial, but having been burnt twice in recent > memory, I'm starting to think it'd be worth setting up a > mechanism to handle such changes automatically. Anyone up > for working on it?
I suppose you want something a bit less trivial than this one, but if somebody has benefit from it, here's the script I've been using to patch my dbs. It's very trivial - error checking is dba-eyeballs, for example. But if there are lots of databases, at least it saves a few steps. A more complete solution would of course require some better error checking ;-) //Magnus
patchpg.sh
Description: patchpg.sh
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])