UniDac 6.4.14 & pgPool 3.3.4 (Postgres)

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Bert1234
Posts: 8
Joined: Fri 25 Mar 2016 15:36

UniDac 6.4.14 & pgPool 3.3.4 (Postgres)

Post by Bert1234 » Wed 12 Oct 2016 08:44

With a TUniConnection I try to connect to a pgPool 3.3.4 but that fails.
After entering Server, Port, Username, Password, I try to get a list of the databases.
The first time I get an empty messagebox with the caption Error.
The second time the messagebox says: Unexpected server response:
Connecting with pgAdmin works fine.

How can I connect to the pgPool? I already tried turning "TUniConnection.Pooling" on and off but that makes no difference.

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: UniDac 6.4.14 & pgPool 3.3.4 (Postgres)

Post by azyk » Thu 13 Oct 2016 10:53

PgDAC is compatible with official PostgreSQL versions. We haven't tested our components compatibility with third-party extensions, such as PGPool.

The TUniConnection.Pooling property is not related to PGPool. This property enables/disables connection pooling in the UniDAC: https://www.devart.com/unidac/docs/?dev ... ooling.htm

Bert1234
Posts: 8
Joined: Fri 25 Mar 2016 15:36

Re: UniDac 6.4.14 & pgPool 3.3.4 (Postgres)

Post by Bert1234 » Fri 14 Oct 2016 08:46

Could you please do a test with connecting to pgpool? Using pgpool is very important for us and we believe the changes to make it work are just minor.
When connecting to pgpool with pgAdmin, the interface is exactly the same. From an application view there is no difference between connecting to a real server or connecting to pgpool.

When I fill in TUniConnection all correct parameters and try to connect with a pgpool I get the following error message:
Unable to get server version
(D:\Projects\Delphi\Dac\PostgreSql\Source\PgSQLProtocol.pas, line 5103)

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: UniDac 6.4.14 & pgPool 3.3.4 (Postgres)

Post by azyk » Tue 18 Oct 2016 09:37

You can leave a suggestion to implement this functionality on our UserVoice page: https://devart.uservoice.com/forums/104 ... components . If the suggestion gets enough user votes, we will consider the possibility to implement it.

Post Reply