Re: Can anyone help setting up pgbouncer?

Richard, you are correct. I was missing the [] headings. Someone sent
me a sample file which didn't have them so I didnt think they were
necessary. I now get...

2009-11-17 12:00:35.809 19575 LOG File descriptor limit: 1024 (H:
1024), max_client_conn: 100, max fds possible: 130

So now the only step I have left is actually connecting. Im trying to
connect a php script to pgbouncer with

$conn = pg_connect("host=127.0.0.1 dbname=bouncer1 port=6543
user=nboutelier password=password");

which results in

Warning: pg_connect(): Unable to connect to PostgreSQL server: could
not connect to server: Connection refused Is the server running on
host "127.0.0.1" and accepting TCP/IP connections on port 6543

Thanks for you help and patience. -Nick

On Nov 17, 3:38 am, d(dot)(dot)(dot)(at)archonet(dot)com (Richard Huxton) wrote:
> Nick wrote:
> > 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
>
> Which is why you have the source. A quick search (grep will do, or
> better still ack/ack-grep) reveals "unconfigured_file" is only used in
> one place. That is initialising the auth-file filename.
>
> So - it isn't seeing the auth_file config setting.
>
> > auth_file = users.tx
>
> You have one, although I'm guessing it's supposed to be "users.txt". So
> - something else is causing it not to be seen.
>
> Do you still have the [...] heading lines? If not, that could well be
> it. It doesn't make sense to me that all you did was change the
> users.txt file and now you get this error.
>
> --
>   Richard Huxton
>   Archonet Ltd
>
> --
> Sent via pgsql-general mailing list (pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general