Re: pgbouncer + psql 9.0a4

Hi Garick,

Add an ignore_startup_parameters to your pgbouncer.ini file
with application_name.

Cheers,
Ken

On Fri, Feb 26, 2010 at 11:26:23AM -0500, Garick Hamlin wrote:
> I was just trying out 9.0a4 and I noticed. That I can't connect to
> pgbouncer with psql from 9.0a4 as a result of the set application_name
> changes to psql.
>
> I imagine this is really mostly pgbouncer's problem, but I couldn't
> figure out how if it was possible to make psql not set application_name
> from the psql man page. If not, at least from a users point of view psql
> 9.0a4 looks incompatible with existing versions of pgbouncer in at least
> in this configuration that works with an older versions of psql.
>
> ... or, is that a crazy way to look at it?
>
> Garick
>
> Details are below..
>
> My setup (Solaris 10 / sparc )
>
> [ psql 9.0a4 ] -> [ pgbouncer 1.3.1 ] -> [ postgres 9.0a4 ]
>
> $ /usr/local/var/postgres/9.0a4/bin/psql -h 127.0.0.1 -p 6543
> psql: ERROR: Unknown startup parameter
>
> ..pgbouncer's log..
> 2010-02-25 21:56:29.721 6979 WARNING C-71d48: (nodb)/(nouser)@127.0.0.1:54000 unsupported startup parameter: application_name=psql
> 2010-02-25 21:56:29.721 6979 LOG C-71d48: (nodb)/(nouser)@127.0.0.1:54000 closing because: Unknown startup parameter (age=0)
> 2010-02-25 21:56:29.722 6979 LOG C-71d48: (nodb)/(nouser)@127.0.0.1:54000 Pooler Error: Unknown startup parameter
>
>
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>