Re: "expected authentication request from server, but received..."

=?iso-8859-2?Q?Micha=B3_J=EAczalik?= <pgsql-hackers(at)jeczalik(dot)com> writes:
> I have a very old postgres 6.4 installation. I'm trying to connect to it
> from a fresh, up-to-date Debian-host, but I'm constantly getting (from DBI
> and PHP as well) this error message:

> # ./update_dns.pl
> DBI connect('dbname=dns;host=sql;authtype=password','dns',...) failed:
> expected authentication request from server, but received U
> at ./update_dns.pl line 237

You certain it's 6.4, and not even older? A look in the CVS logs says
that we were using protocol 2.0 starting in 6.4, so current libpq should
still talk to it.

> P.S. Don't tell me to upgrade postgres :) It must stay like that for some
> reasons which are beyond me.

6.4 *will* eat your data eventually. Don't say you weren't warned.

regards, tom lane