CODEWITHSUNDEEP
windowspostgresqlreplicationload-balancingpgpool
Konrad
Konrad

Reputation: 1014

Load balancing PostgreSQL with Windows Servers

I have a question concerning the possibilities of load balancing when using PostgreSQL with Windows Servers. On Unix systems this is made possible by using pgpool-II. How can I achieve the same with Windows?

I know that you cannot mix systems when it comes to replication. Pgpool documentation states:

Can I mix different platforms of PostgreSQL as pgpool-II backends, for example Linux and Windows?

In streaming replication mode, no

What about a different scenario? Can I run pgpool on a Unix machine, and configure replication & load balancing on a pool of Windows Servers?

I'm using Windows Server 2008 R2 in case it matters.

Upvotes: 1

Views: 2960

Answers (1)

Craig Ringer
Craig Ringer

Reputation: 324901

Can I run pgpool on a Unix machine, and configure replication & load balancing on a pool of Windows Servers?

Yes, you can. That's probably the best option in your situation, barring porting PgPool-II to Windows.

However, I suspect that load balancing across read replicas isn't necessary most of the time people do it, and that appropriate database tuning, indexing and configuration is often sufficient.

Upvotes: 6

Related Questions