On Sun, Nov 20, 2011 at 4:14 AM, Phoenix Kiula <phoenix.ki...@gmail.com>wrote:
> On Sun, Nov 20, 2011 at 3:35 AM, Adrian Klaver <adrian.kla...@gmail.com> > wrote:<snip> > > [databases] > MYDB = host=127.0.0.1 dbname=MYDB user=MYUSER client_encoding=utf8 > port=5432 > > ;; Configuation section > [pgbouncer] > logfile = /var/log/pgbouncer.log > pidfile = /var/run/pgbouncer/pgbouncer.pid > ; ip address or * which means all ip-s > listen_addr = 127.0.0.1 > listen_port = 6543 > auth_type = trust > auth_file = /var/lib/pgsql/pgbouncer.txt > > admin_users = postgres > stats_users = stats, root > pool_mode = session > server_reset_query = DISCARD ALL > > ;;; Connection limits > ; total number of clients that can connect > max_client_conn = 1500 > default_pool_size = 50 > > I am assuming the difference in the port numbers between your config file and php code is a typing error. Does the auth file (/var/lib/pgsql/pgbouncer.txt) contain valid login credentials to your database? If I remember correctly, it should have the username and password to your database. Amitabh
