Just answer the F*#king question

I use this for insert records into a queue. To avoid overload one day, just split the records up over a number of days ….

now() + INTERVAL rand()*2 day + INTERVAL 2 hour

request.getHeader("user-agent");

.. this is me just dumping my brain from the office after installing pgbouncer. FYI it works great, and really does improve the speed for db generated web pages. Don’t take this as THE install method, this is just notes so I can remember how to do it again

Get the source from pgfoundry ( I put it in /usr/local )
wget http://pgfoundry.org/frs/download.php/2284/pgbouncer-1.3.1.tgz


Unpack it
gunzip -c pgbouncer-1.3.1.tgz | tar -xv


Get / unpack / make libevent if not already installed
wget http://www.monkey.org/~provos/libevent-1.4.12-stable.tar.gz
gunzip -c libevent-1.4.12-stable.tar.gz | tar -xv
cd libevent-1.4.12-stable
./configure
make
make install


Back to pgbouncer
cd pgbouncer-1.3.1
./configure
make
make install


Move the ini and user files to /etc so I know where they are
mv etc/pgbouncer.ini /etc/
mv userlist.txt /etc/


Edit the userlist.txt to add user
Edit the pgbouncer.ini to point to new locations
auth_file = /etc/userlist.txt
logfile = /var/log/pgbouncer.log
pidfile = /tmp/pgbouncer.pid


Add libevent module ( fixed library not found error )
vi /etc/ld.so.conf.d/libevent-i386.conf

add line
/usr/local/lib


Run ldconfig to take new settings
ldconfig


I added the following to the START of postgresql in /etc/init.d
$SU -l postgres -c "pgbouncer -d /etc/pgbouncer.ini"


ls -l|sort -n +4

Just another so of bug that came up today when trying to upgrade to Snow Leopard. After the “pre-install” the Mac would reboot but eject the DVD and continue as normally. Trying other boot disks, even Ctrl+C would eject the disk and boot normally.

The issue was a third party mouse. Plugged back in my normal apple mouse and … wow .. back up and working!