I've painted myself into a little corner here:
I pg_dumped a 7.4.3 database, created a database of the same name on a
7.3.4 server, psql'd into the new database, and \i'd the dump file.
The database was created although there were a variety of errors which I
realized were due to 7.4.3 and 7.3
Bucks vs Bytes Inc <[EMAIL PROTECTED]> writes:
> Any thoughts on what could make both clients attempt wrong protocol?
They are both using 7.4-or-later libpq. Whether you think so or not.
regards, tom lane
---(end of broadcast)-
Connection logging shows an unvarying pattern: every connection
attempt, regardless of target database or source (PHP or psql), first
uses a wrong protocol and then succeeds on a second attempt, presumably
after falling back:
LOG: connection received: host=[local]
FATAL: unsupported frontend
Bucks vs Bytes Inc <[EMAIL PROTECTED]> writes:
> Is there any postmaster logging I can turn on that will detail what's
> triggering the error?
Well, you could change the error report in postmaster.c to show the
specific protocol version code it's receiving (7.4 and up do this,
but it hadn't occur
Agreed that the symptom fits a client library mismatch, but the only
thing I moved from the 7.4.3 system to the 7.3.4 system was a pg_dump'ed
database. That can't carry anything that would affect the interaction
between the existing PHP 4.2.2 and PostgreSQL 7.3.4 versions, can it?
They worked w
Bucks vs Bytes Inc <[EMAIL PROTECTED]> writes:
> The database was created although there were a variety of errors which I
> realized were due to 7.4.3 and 7.3.4 SQL incompatibilities. I had also
> added a new entry to pg_hba.conf. After restarting the 7.3.4 postmaster
> I started getting an endless
I've painted myself into a little corner here:
I pg_dumped a 7.4.3 database, created a database of the same name on a
7.3.4 server, psql'd into the new database, and \i'd the dump file.
The database was created although there were a variety of errors which I
realized were due to 7.4.3 and 7.3.4
When I try to use postgres 6.5 from a client that
is not logged on the localhost. I get this :
Connection to database 'mydb'
failed
Unsupported frontend
protocol.
I've seen the same problem in a previous mail but
the error may not come from the postmaster, that is not enough recent because
I'm trying to connect to a database from a C++ program compiled with
g++, linked to the libpq library on a Sun Solaris system. It is compiled
and run like this (my actual information has been changed to pseudonyms,
like mypghost.com, etc.)
bash$ gmake
g++ -c -I /usr/local/pgsql/include test1.cpp
