[unixODBC-support] help me, unixODBC connection when switching VIP

Dang Minh Huong kakalot49 at gmail.com
Tue Dec 11 22:52:00 GMT 2012


Hi,

Thanks for your kind reply.
I'll check the postgresql-odbc driver which i'm using.

Regards,

Huong

On 2012/12/12, at 0:23, Nick Gorham <nick at lurcher.org> wrote:

> On 11/12/12 15:10, Dang Minh Huong wrote:
>> Hi,
>> 
>> I'm using unixODBC for my HA project with following construction.
>> 
>> - 2 PostgreSQL nodes (ACTIVE and STANDBY)
>> - the application using unixODBC and access to ACTIVE DB node by a
>> Virtual IP adress.
>> 
>> I got a problem when switching over Virtual IP from ACTIVE node to
>> STANDBY node.
>> 
>> When my switching process finished (now the Vitual IP is switched to the
>> STANDBY)
>> the results as follows.
>> (1). in the ACTIVE node, connected connection is not disconnected
>> (2). connected connection can execute SQL query
>> (I have tested with my AP and isql).
>> 
>> I'm actually want to get the disconnection from (1). or an error from (2).
>> when the switching process finished. Any body can help me how to setting
>> odbc.ini file to get it.
>> 
>> If you know please answer my question about unixODBC connection pool.
>> When switched, is there a connection pool setting in order to the connected
>> connection on ACTIVE node can execute the next SQL query on the
>> STANDBY node.
>> 
>> I'm a new to unixODBC, i'm so sorry if this contents are posted in the past.
>> 
>> Thank you very much.
>> 
>> Regards,
>> Dang Minh Huong
>> _______________________________________________
>> unixODBC-support mailing list
>> unixODBC-support at mailman.unixodbc.org
>> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
> Hi,
> 
> It sounds more like a issue for the driver, I think you need something like the TAF callback that Oracle provides (I know as we added support for this to the Easysoft driver a few months ago). I don't know if Postgres has anything similar to alert the calling application that the connection is nolonger valid.
> 
> -- 
> Nick
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support


More information about the unixODBC-support mailing list