Connecting to a 7.1 DB with 7.3 psql - Mailing list pgsql-general

From Roland Glenn McIntosh
Subject Connecting to a 7.1 DB with 7.3 psql
Date
Msg-id 5.1.0.14.2.20030314122815.06290b28@lnxmain
Whole thread Raw
Responses Re: Connecting to a 7.1 DB with 7.3 psql
List pgsql-general
I'm having trouble connecting to a 7.1 database with the 7.3.2 client.
It seems that my user privileges are severely restricted.
Check out this interaction:

----------------------------------
[demo@trout ~/database_dumps]# psql -Usts -h winnie sts
ERROR:  parser: parse error at or near "."
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

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

sts=> select version();
                           version
--------------------------------------------------------------
 PostgreSQL 7.1.3 on i686-pc-cygwin, compiled by GCC 2.95.3-5
(1 row)

sts=> \l
ERROR:  parser: parse error at or near "("
sts=>
----------------------------------

The version of psql is obviously 7.3.2.  I compiled it myself from the SRPMs from postgresql.org on this RedHat 6.2
system(trout).  The server is obviously running on cygwin, and I don't suspect that's the problem.  What could be
happeninghere?  User sts owns the database named sts.  Connecting with a 7.1 client works fine. 

I'd appreciate any suggestions!

-Roland



pgsql-general by date:

Previous
From: James Hall
Date:
Subject: Re: Pg_hba not using local setting
Next
From: Tony Grant
Date:
Subject: Re: PostgreSQL and XML