Re: Can anyone help setting up pgbouncer?

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

Do I need to open up port 6543 using iptables or something?