Thanks Richard, I updated my users.txt file to include quotes (it didn't) which fixed the broken auth file error, but now im getting this... 1518 ERROR unconfigured_file: No such file or directory which repeats over and over again when I try pgbouncer -v pgbouncer.ini I updated my ini file to this: bouncer1 = host=127.0.0.1 port=5432 dbname=bouncer1 bouncer1 = host=127.0.0.1 dbname=bouncer1 bouncer1 = host=127.0.0.1 port=5432 user=nboutelier password=password logfile = pgbouncer.log pidfile = pgbouncer.pid listen_port = 6543 listen_addr = 127.0.0.1 auth_type = trust auth_file = users.tx admin_users = nboutelier On Nov 13, 1:58 am, d...@xxxxxxxxxxxx (Richard Huxton) wrote: > Nick wrote: > > Im trying to set up pgbouncer. Installation seemed to go well but when > > I try... > > > $ pgbouncer -d pgbouncer.ini > > > I get an error... > > > 2009-11-13 02:02:35.170 7245 ERROR broken auth file > > It's complaining about your auth file, rather than pgbouncer.ini > > > Here is my pgbouncer.ini file... > > auth_file = users.txt > > 1. Perhaps have a full path to the file here. > 2. Check permissions/ownership on users.txt > 3. Check the format of the file - each line should be <user> <password> > with space between and double-quotes around each. > "myuser" "mypassword" > 4. Run with -v rather than -d and see if you get any useful info on STDERR > > -- > Richard Huxton > Archonet Ltd > > -- > Sent via pgsql-general mailing list (pgsql-gene...@xxxxxxxxxxxxxx) > To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
