Problem with PostgreSQLDirect + PGCluster Servers
Posted: 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
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