I ran into the same problem and it turned out to be an outdated version of
psql. Check your path to see if you are accessing the correct version of
psql, pg_dump etc..
-Dan Wilson
----- Original Message -----
From: Howie <caffeine@toodarkpark.org>
To: postgres <pgsql-general@postgreSQL.org>
Cc: <caffeine@toodarkpark.org>
Sent: Friday, June 25, 1999 5:22 PM
Subject: [GENERAL] problem with PostgreSQL 6.5 on Linux
>
> after installing pgsql-6.5 ( on a machine with pgsql-6.4.2 installed and
> running ), initdb creates a PG_VERSION file that still reports 6.4;
> subsequent psql connections fail to connect, complaining about "no
> compatible version of postgres found".
>
> before you ask:
> yes, ive made sure that im using 6.5's initdb.
> yes, ive made sure that initdb is looking in the 6.5 dir for its template.
> yes, its writing to a 6.5 dir.
>
> so, errr, what gives?
>
> ---
> Howie <caffeine@toodarkpark.org> URL: http://www.toodarkpark.org
> "The distance between insanity and genius is measured only by success."
>
>