Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA37469; Mon, 3 Jan 2000 10:12:15 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id KAA08140; Mon, 3 Jan 2000 10:12:14 -0500 (EST) To: Michael Meskes cc: "'pgsql-interfaces@postgresql.org'" Subject: Re: [INTERFACES] still cannot connect with pgAdmin In-reply-to: <20000103115710.F1357@fam-meskes.de> References: <20000103115710.F1357@fam-meskes.de> Comments: In-reply-to Michael Meskes message dated "Mon, 03 Jan 2000 11:57:10 +0100" Date: Mon, 03 Jan 2000 10:12:14 -0500 Message-ID: <8137.946912334@sss.pgh.pa.us> From: Tom Lane Michael Meskes writes: > On Sun, Jan 02, 2000 at 09:53:12AM -0000, Dave Page wrote: >> To work correctly, the major and minor version numbers of the database >> should be the same as pgAdmin's (eg. 6.5.x PostgreSQL will work with 6.5.x >> pgAdmin). In the case of pgAdmin 6.5.x, it is looking at the first 14 >> characters returned by the SELECT which are expected to be: >> >> PostgreSQL 6.5 >> >> If they are not, then you get the error you've experienced. > But checking with psql I get > timesheet=> select version(); > version > ------------------------------------------------------------- > PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc 2.95.2 > (1 row) > timesheet=> Before you spend too much time digging for a bug in pgAdmin, check the possibility that it's connecting to some other database server than you think it is. Just a thought... regards, tom lane