psql version 7.3 can't connect postgres DB version 7.2.3 - using SSH port forwarding

From: Steffen Schmidt <schmidt(at)EMBL-Heidelberg(dot)DE>
To: pgsql-ports(at)postgresql(dot)org
Subject: psql version 7.3 can't connect postgres DB version 7.2.3 - using SSH port forwarding
Date: 2002-11-29 10:21:36
Message-ID: 200211291121.36290.schmidt@EMBL-Heidelberg.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports

Your name : Steffen Schmidt
Your email address : SSchmid6(at)urz(dot)uni-heidelberg(dot)de

System Configuration
---------------------
Architecture : i686 (AMD Athlon)
Operating System : Linux 2.4.18.SuSE
PostgreSQL version : PostgreSQL-7.3 / PostgreSQL-7.2.3
Compiler used : gcc 2.95.3

Please enter a FULL description of your problem:
------------------------------------------------
Just compiled the sources and installed it - seems to work fine ;-) BUT:
I want to access another Postgres database running on version 7.2.3 on another
host, so I normally forward the port 5432(remote) to 5433(local) via ssh.
Typing psql -p 5433 -h localhost mydb works fine for all previous versions of
PostgreSQL but not with 7.3!
I get the error message:
ERROR: parser: parse error at or near "("

Any clue?
Thanks
Steffen

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
Start PostgreSQL version 7.2.3 on other host
modify pg_hba.conf for local access with full IP-Address
start postmaster with option -i
Forward port 5432 from remote host to local host via ssh
ssh -L 5433:remote_host:5433 remote_host
Try to access remote DB with psql (Version 7.3):
psql -p 5433 -h localhost -l

=> ERROR: parser: parse error at or near "("

Responses

Browse pgsql-ports by date

  From Date Subject
Next Message Tom Lane 2002-12-03 07:18:46 Re: psql version 7.3 can't connect postgres DB version 7.2.3 - using SSH port forwarding
Previous Message Derek M. A. Lee-Wo 2002-11-26 14:01:58 Can't run psql and other utilities under AIX