Received: from water2.cs.umass.edu (water2.cs.umass.edu [128.119.40.165]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA80568 for ; Sun, 1 Aug 1999 17:51:14 -0400 (EDT) (envelope-from clynch@water2.cs.umass.edu) Received: (from clynch@localhost) by water2.cs.umass.edu (8.8.8/8.8.7) id RAA22161; Sun, 1 Aug 1999 17:49:51 -0400 (EDT) Date: Sun, 1 Aug 1999 17:49:51 -0400 (EDT) From: "Collin F. Lynch" Message-Id: <199908012149.RAA22161@water2.cs.umass.edu> To: tgl@sss.pgh.pa.us Subject: Re: [INTERFACES] libpgtcl.so.2.0 Tom Wins a Nickel. Cc: lockhart@alumni.caltech.edu, pgsql-interfaces@postgreSQL.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-MD5: J1DaL4FcCjLyGK0AUtHXhQ== > From tgl@sss.pgh.pa.us Fri Jul 30 19:08:30 1999 > To: "Collin F. Lynch" > cc: lockhart@alumni.caltech.edu, pgsql-interfaces@postgreSQL.org > Subject: Re: [INTERFACES] libpgtcl.so.2.0 > In-reply-to: Your message of Fri, 30 Jul 1999 15:35:52 -0400 (EDT) <199907301935.PAA20190@water2.cs.umass.edu> > Date: Fri, 30 Jul 1999 19:09:05 -0400 > From: Tom Lane > Content-Length: 633 > > "Collin F. Lynch" writes: > > I am now attempting to execute my > > script in pgtclsh and am being told: > > > Connection to database failed > > Unsupported frontend protocol. > > while executing > > "pg_connect $Database -host $Host" > > > The Server in QUestion is 6.5-1 running on a pure Redhat 6.0 (intel) box. > > I'll bet a nickel that your client is actually connecting to your 6.3 > server, not the 6.5 one. Check host names, port numbers, TCP vs > Unix-socket protocol. One conclusive check is to see which postmaster's > error log gets a copy of the "unsupported protocol" gripe... > > regards, tom lane You had it right an errant line was resetting the hostname on the database after I had set it properly. Collin Lynch.