Обсуждение: Seek info on 7.4.23 server/8.1.1 psql compatibility issues.

Greetings,

I have a functioning 7.4.23 server on Debian 4, 32-bit.

I connect fine using 7.4.23 remote clients.

Remote connections from an 8.1.1 psql client on SUSE, 64-bit, hang after
the password prompt appears and a password is entered.

However, the 7.4.23 server log indicates that a valid connection was made.

Network connectivity otherwise between the two computers is normal.

Is anyone aware of known compatibility issues?  If so, can you point me
to documentation, troubleshooting tips, etc?

Thanks.

Ken Banyas

Kenneth Banyas <kenneth.banyas-1@nasa.gov> writes:
> I have a functioning 7.4.23 server on Debian 4, 32-bit.

> I connect fine using 7.4.23 remote clients.

> Remote connections from an 8.1.1 psql client on SUSE, 64-bit, hang after
> the password prompt appears and a password is entered.
> However, the 7.4.23 server log indicates that a valid connection was made.

Hm... the case works for me:

$ psql ...
Welcome to psql 8.1.18 (server 7.4.26), the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

WARNING:  You are connected to a server with major version 7.4,
but your psql client is major version 8.1.  Some backslash commands,
such as \d, might not work properly.

regression=#

One thing to check is whether you have a ~/.psqlrc containing commands
that wouldn't work against the older server.  Failing that, I'm going
to bet that this is a firewall issue of some sort.

            regards, tom lane