Re: [Postgres-xc-developers] pgxc_pool_reload() Does not Drop Connections

[Koichi S. <koi...@gm...>]

Sorry for the late response.   pgxc_pool_reload() is needed to
synchronize cluster configuration change.   Could you try CLEAN
CONNECTION as found in
http://postgres-xc.sourceforge.net/docs/1_1/sql-cleanconnection.html?

BTW, as I wrote in the bug tracking #473, it does not seem to be
search_path propagation, but another XC internal.

Regards;
---
Koichi Suzuki


2014-02-01 David E. Wheeler <da...@ju...>:
> XCers,
>
> In order to work around the search_path bug (https://sourceforge.net/p/postgres-xc/bugs/473/), I added ALTER DATABASE commands to my deployment stuff to set the search path for the database to include all my schemas. However, this change does not affect users currently connected to the database -- including pooled connections to the data nodes. I thought that pgxc_pool_reload() would do the trick. Its docs:
>
>> pgxc_pool_reload reloads connection data cached in pooler from pgxc_node catalog and reloads all the information info cached in pooler. All the active transactions are aborted and all existing pooler connections are dropped. This results in having all the temporary and prepared objects dropped on remote and local node for session.
>
> So I called it, it returned true, and then I tried to insert into a table with a column of a type defined in a schema in the search path, but it failed, saying it could not find the type. So I connected to each data node and called pg_terminate_backend() on every connection to the database, then ran my insert statement again -- and it worked.
>
> So I guess that pgxc_pool_reload() does not disconnect from data nodes and reconnect. It keeps using existing connections. Is that how it should be? The docs say "all existing pooler connections are dropped", but such did not seem to be the case for me. Did I do it right?
>
> Thanks,
>
> David
>
>
> ------------------------------------------------------------------------------
> WatchGuard Dimension instantly turns raw network data into actionable
> security intelligence. It gives you real-time visual feedback on key
> security issues and trends.  Skip the complicated setup - simply import
> a virtual appliance and go from zero to informed in seconds.
> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers