Re: Slony uninstall info/warning - Mailing list pgsql-general

From Christopher Browne
Subject Re: Slony uninstall info/warning
Date
Msg-id m3sm3xodh7.fsf@knuth.knuth.cbbrowne.com
Whole thread Raw
In response to Slony uninstall info/warning  (John Sidney-Woollett <johnsw@wardbrook.com>)
Responses Re: Slony uninstall info/warning
List pgsql-general
In an attempt to throw the authorities off his trail, johnsw@wardbrook.com (John Sidney-Woollett) transmitted:
> MAKE SURE YOU STOP YOUR APPLICATION RUNNING AGAINST YOUR MASTER
> DATABASE WHEN REMOVING THE WHOLE SLONY CLUSTER, or at least re-cycle
> all your open connections after the event!
>
> The connections appear to "remember" or refer to objects which are
> removed by the uninstall node script. And you get lots of errors as a
> result (and possible data loss??)...

As has been noted by others, this is an artifact of the JDBC driver
holding onto a stored query plan.  And it's somewhat worth noting that
this is not unique to Slony-I...

I have added warnings to relevant documentation in the Slony-I CVS
tree.  This may also be worthy of a FAQ note for PostgreSQL itself,
and is almost certainly worthy of note in the JDBC documentation...
--
(format nil "~S@~S" "cbbrowne" "acm.org")
http://linuxdatabases.info/info/slony.html
"We should start referring to processes which run in the background by
their correct technical name:... paenguins."  -- Kevin M Bealer

pgsql-general by date:

Previous
From: Dan Sugalski
Date:
Subject: Re: CURSORs and selects with parameters
Next
From: Jeff Amiel
Date:
Subject: Schema comparison tool