PGPool-II 3.6
Posted: Thu 06 Jul 2017 19:24
I am running PGPool II 3.6 on his own machine in front of 2 PostgreSQL servers.
After a lot of struggling with configuration and settings, this configuration works very nice in Master/Slave mode with streaming replication.
As well, I can connect and run SQL query’s, as well nice surrounded with transactions (IsolationLevel.Serializable)
But if I use inside a transaction with IsolationLevel Serializable a Devart.Data.PostgreSql.PgSqlLoader, I run in the problems that the command will never returned (finished) on pgpool.
I found similar error descriptions inside the forum, but all of them for years old. The only difference is, that I have the problem only if I use the loader.
The versions I use:
PGPool 3.6
PostgreSQL 9.4
dcpostgresql76pro
Do you have any hint how to use the loader within this configuration?
I tried to disable pooling on both sides, as well all IsolationLevel and Protokoll 2 and 3, no success
Many thanks in advance
Thomas
After a lot of struggling with configuration and settings, this configuration works very nice in Master/Slave mode with streaming replication.
As well, I can connect and run SQL query’s, as well nice surrounded with transactions (IsolationLevel.Serializable)
But if I use inside a transaction with IsolationLevel Serializable a Devart.Data.PostgreSql.PgSqlLoader, I run in the problems that the command will never returned (finished) on pgpool.
I found similar error descriptions inside the forum, but all of them for years old. The only difference is, that I have the problem only if I use the loader.
The versions I use:
PGPool 3.6
PostgreSQL 9.4
dcpostgresql76pro
Do you have any hint how to use the loader within this configuration?
I tried to disable pooling on both sides, as well all IsolationLevel and Protokoll 2 and 3, no success
Many thanks in advance
Thomas