Re: [Pgbouncer-general] Again, problem with pgbouncer - Mailing list pgsql-general

From Marko Kreen
Subject Re: [Pgbouncer-general] Again, problem with pgbouncer
Date
Msg-id CACMqXC+AOutVxYPWrjuS5AopHTmE-2sExRa=-sXkOTY+XivbQg@mail.gmail.com
Whole thread Raw
In response to Re: Again, problem with pgbouncer  (Phoenix Kiula <phoenix.kiula@gmail.com>)
List pgsql-general
On Tue, Oct 2, 2012 at 12:27 PM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
> I get this error:
>
>    psql: ERROR:  No such user: MYSITE_MYSITE
>
> And yet, the authfile has this:
>
>     "MYSITE_MYSITE" "<md5 of raw password>"
>     "MYSITE_MYSITE" "<raw password>"
>     "postgres" "<md5 of string>"
>     "MYSITE_pgbouncer" ""

Because of data sanitizing I cannot see actual problem,
but few hints:

- Don't give one username several times (pgbouncer uses just one of them)
- Usernames are case-sensitive
- Username max length is 63 chars

--
marko


pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: postgres 9.1 pgsql_tmp directory location of specific database?
Next
From: Marko Kreen
Date:
Subject: Re: [Pgbouncer-general] Again, problem with pgbouncer