Re: Can anyone help setting up pgbouncer?

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