Thread: PGbouncer for Windows 2008
Hello,
Can anyone please tell me where I can find the PGbouncer executable and tutorial for Windows 2008? I found one but need to recompile on Windows. I also need intuitive instructions to configure it too.
Thanks in advance.
--
Edison
--
Edison
http://winpg.jp/~saito/pgbouncer/
On Fri, Jan 20, 2012 at 11:01 PM, Edison So <edison.so2@gmail.com> wrote:
Hello,Can anyone please tell me where I can find the PGbouncer executable and tutorial for Windows 2008? I found one but need to recompile on Windows. I also need intuitive instructions to configure it too.Thanks in advance.
--
Edison
Thank you for the reply.
--
Edison
I downloaded the 64-bit version and extracted it. Unfortunately. it seems that the pbbouncer.exe file is needed to be rebulit (ie. recompiled) according to the following statements from the README file:
-------------------------------------------------
Building for WIN32
------------------
At the moment only build env tested is MINGW32 / MSYS. Cygwin
and Visual $ANYTHING are untested. Libevent 2.x is required
for DNS hostname lookup.
Then do the usual:
$ ./configure ...
$ make
If cross-compiling from Unix:
$ ./configure --host=i586-mingw32msvc ...
Running on WIN32
----------------
Running from command-line goes as usual, except -d (daemonize),
-R (reboot) and -u (switch user) switches will not work.
To run pgbouncer as a Windows service, you need to configure
`service_name` parameter to set name for service. Then:
$ pgbouncer -regservice config.ini
To uninstall service:
$ pgbouncer -unregservice config.ini
To use Windows Event Log, set "syslog = 1" in config file.
But before you need to register pgbevent.dll:
$ regsvr32 pgbevent.dll
To unregister it, do `regsvr32 /u pgbevent.dll`.
-------------------------
I do not have a SDE environment to rebuild the ,exe file. Any other idea?
Cheers,
On Sat, Jan 21, 2012 at 8:40 AM, tuanhoanganh <hatuan05@gmail.com> wrote:
http://winpg.jp/~saito/pgbouncer/On Fri, Jan 20, 2012 at 11:01 PM, Edison So <edison.so2@gmail.com> wrote:Hello,Can anyone please tell me where I can find the PGbouncer executable and tutorial for Windows 2008? I found one but need to recompile on Windows. I also need intuitive instructions to configure it too.Thanks in advance.
--
Edison
Edison
On 01/22/12 4:55 PM, Edison So wrote: > > I downloaded the 64-bit version and extracted it. Unfortunately. it > seems that the pbbouncer.exe file is needed to be rebulit (ie. > recompiled) according to the following statements from the README file: those statements you reference may well be from the generic pgbouncer source readme. if someone has already built and tested a 64bit binary, whats the problem? -- john r pierce N 37, W 122 santa cruz ca mid-left coast
Hi. John-san, thanks! to Edison-san. It is necessary to perform it in an administrator's mode. Please see, http://winpg.jp/~saito/pgbouncer/try_64bit/regsvr32_pgevent.png http://winpg.jp/~saito/pgbouncer/try_64bit/running_pgbouncer.png Regards, Hiroshi Saito (2012/01/23 10:09), John R Pierce wrote: > On 01/22/12 4:55 PM, Edison So wrote: >> >> I downloaded the 64-bit version and extracted it. Unfortunately. it >> seems that the pbbouncer.exe file is needed to be rebulit (ie. >> recompiled) according to the following statements from the README file: > > those statements you reference may well be from the generic pgbouncer > source readme. if someone has already built and tested a 64bit binary, > whats the problem? > > >
