> 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

Attachment: 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])

Reply via email to