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 "("
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 |