On 6/16/11, Cédric Villemain <cedric.villemain.debian@xxxxxxxxx> wrote: > 2011/6/16 Alexander Farber <alexander.farber@xxxxxxxxx>: >> I'm still suffering with my Drupal 7.2 site and >> PostgreSQL 8.4.8 every evening, for example >> right now. I have tried different combinations >> for /etc/pgbouncer.ini - for example now I have: >> >> [pgbouncer] >> logfile = /var/log/pgbouncer.log >> pidfile = /var/run/pgbouncer/pgbouncer.pid >> ;listen_addr = 127.0.0.1 >> listen_port = 6432 >> unix_socket_dir = /tmp >> >> auth_type = md5 >> auth_file = /var/lib/pgsql/data/global/pg_auth >> >> pool_mode = session >> > > you probably want to use transaction mode here, instead of session. > Is transaction mode better for PHP scripts with persistent connections? I'll try that, thank you (rebooting right now... GPRS sucks) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general