Problem with PostgreSQLDirect + PGCluster Servers

Problem with PostgreSQLDirect + PGCluster Servers

Postby zxiv1001 » Tue 22 Nov 2005 12:50

Hi,

Our existing .NET applications are using PostgreSQLDirect .NET 2.20 (for .NET Framework 1.x). When we tried our applications againts PGCluster-1.3.0c (http://pgfoundry.org/projects/pgcluster/), all write operations does not get replicated to other nodes. Gborg's NPGSql data provider, however, works. And likewise, EMS PG Manager UI works againts PGCluster-1.1.1a (PGSQL-7.4.7 flavor of PGCluster).

My questions now are as follows:

1. Is this a design issue with PostgreSQLDirect?
2. Is it possible to change PostgreSQLDirect so that it will communicate similarly with other data providers/clients? (we really don't mind sacrificing speed over functionality at this time)
3. Can anyone suggest any known (_to_be_stable_) PGDB replication-ware in Linux wherein PgSQLDirect works cleanly?

As much as possible, our company wishes to keep our current implementations intact, and make them work with our PGCluster servers. But we're also open to any suggestions as long as we'll keep our .NET/PostgreSQLDirect side of this matter intact.

All inputs are greately appreciated.

Best Regards,
Vic
zxiv1001
 
Posts: 2
Joined: Wed 09 Nov 2005 09:20

Communication protocol downgrade

Postby zxiv1001 » Thu 24 Nov 2005 06:37

Hi Oncemore,

It seems downgrading the protocol from default did it! At least we have something to battery test now.

Vic
zxiv1001
 
Posts: 2
Joined: Wed 09 Nov 2005 09:20


Return to dotConnect for PostgreSQL