Object Explorer crashes randomly while connected to PostgresSQL on Amazon Redshift
说明
Having issues using Object Explorer, in Toad Data Point 3.6 and 3.7, when connected to PostgreSQL on Amazon Redshift. The Object Explorer will cause crashing while working in it at times. Nothing seems to be reproducible on demand.
原因
Amazon Redshift has had many problems with it's ODBC drivers. The problem is the Keep Alive option does not keep the connection connected.
解决办法
Use PostgreSQL ODBC driver version 09_03_0400.
On the advance tab, set the Keep Alive options to 120 and 60.
Attached to this KB article is a copy of the driver and a document with instructions on how to set these options.
