1

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.

Community
  • 1
  • 1
Konrad
  • 1,014
  • 1
  • 13
  • 24

1 Answers1

6

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.

Craig Ringer
  • 307,061
  • 76
  • 688
  • 778