'How to install PgBouncer on Windows 7 (x64)
I am attempting to install PgBouncer on my computer with no success. In the installation page, im told that PgBouncer has two dependencies GNU Make 3.81+ and libevent 2.0. Never having used or heard of these two software before, Im completely lost.
I have read a little on both but have yet to find or fully understand what they actually do and how they will help me set up PgBouncer. From what I've read, PgBouncer does not come compiled for windows and I need the other two to compile it. I have searched for tutorials online but it seems that im falling into a black hole of misunderstanding.
Im looking for a simple explanation on how to install PgBouncer or how these software work with one another. Thanks.
Solution 1:[1]
If anyone now searches the binaries because http://winpg.jp/~saito/pgbouncer is offline now, check out my page under https://sepppenner.github.io/PgBouncerWinBinaries/. I have all the binaries from the Saito page but didn't yet succeed to build the project on my own. If anyone has ideas, don't hesitate to contact me here or on Github :)
EDIT: I'm now able to build pgbouncer for windows just having some issues with the pandoc thing (Follow https://github.com/pgbouncer/pgbouncer/issues/442). I will provide binaries soon. The instructions are already online under the page listed above :)
Solution 2:[2]
Im looking for a simple explanation on how to install PgBouncer
A little late, but if you use the EDB installer for PostgreSQL, as linked on postgresql.org (https://www.postgresql.org/download/windows/), you can install Stack Builder. From inside Stack Builder, PgBouncer can be installed (EDB build).
Unfortunately, it's not the latest version. Now, PgBouncer 1.17.0 is available and Stack Builder provides 1.16.1.
Personally, I don't understand why the PgBouncer project doesn't just offer a Windows build. So everybody would be able to get the latest release.
Solution 3:[3]
I have not messed with pgbouncer in years but have had multiple comments on what I did to solve my problem.
In the link bellow is the pgbouncer build I last used on my project. From what I remember, all you would need to do is replace the users in the config/user.txt with yours and go into config/pgbouncer.ini and change the configuration to work with your set up. To start it, just run the run.bat file or pgbouncer.exe config/pgbouncer.iniin the cmd prompt. You want to download everything in the folder.
https://drive.google.com/open?id=1f8MjdQCq-ryQBiJ85d4hABASFfR_6fA2
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | |
| Solution 2 | nadine |
| Solution 3 | Nimantha |