PGbouncer for Windows 2008

http://winpg.jp/~saito/pgbouncer/

On Fri, Jan 20, 2012 at 11:01 PM, Edison So <edison.so2@gmail.com> wrote:

Thank you for the reply.

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: