Connecting to a 7.1 DB with 7.3 psql

From: Roland Glenn McIntosh <roland(at)steeltorch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Connecting to a 7.1 DB with 7.3 psql
Date: 2003-03-14 17:28:20
Message-ID: 5.1.0.14.2.20030314122815.06290b28@lnxmain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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 happening here? User sts owns the database named sts. Connecting with a 7.1 client works fine.

I'd appreciate any suggestions!

-Roland

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Grant 2003-03-14 17:41:43 Re: PostgreSQL and XML
Previous Message James Hall 2003-03-14 17:25:53 Re: Pg_hba not using local setting