From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!.POSTED!not-for-mail From: Jean Louis Newsgroups: gmane.emacs.help Subject: Re: pg.el: pg:connect -> Backend error: FATAL unsupported frontend protocol 1.0: server supports 2.0 to 3.0 Date: Wed, 28 Nov 2018 03:48:10 +0100 Organization: GOLDIVANTI GOLD LIMITED Message-ID: <20181128024810.GU22109@protected.rcdrun.com> References: NNTP-Posting-Host: blaine.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Trace: blaine.gmane.org 1543373229 5539 195.159.176.226 (28 Nov 2018 02:47:09 GMT) X-Complaints-To: usenet@blaine.gmane.org NNTP-Posting-Date: Wed, 28 Nov 2018 02:47:09 +0000 (UTC) User-Agent: Mutt/1.10.1 (2018-07-13) Cc: help-gnu-emacs@gnu.org To: Martin Steffen Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Wed Nov 28 03:47:05 2018 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([208.118.235.17]) by blaine.gmane.org with esmtp (Exim 4.84_2) (envelope-from ) id 1gRpsW-0001Ns-Bf for geh-help-gnu-emacs@m.gmane.org; Wed, 28 Nov 2018 03:47:04 +0100 Original-Received: from localhost ([::1]:45587 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gRpuc-0003Tf-NY for geh-help-gnu-emacs@m.gmane.org; Tue, 27 Nov 2018 21:49:14 -0500 Original-Received: from eggs.gnu.org ([2001:4830:134:3::10]:55589) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gRpth-0003Sc-EV for help-gnu-emacs@gnu.org; Tue, 27 Nov 2018 21:48:18 -0500 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1gRpte-0007v9-0n for help-gnu-emacs@gnu.org; Tue, 27 Nov 2018 21:48:17 -0500 Original-Received: from stw1.rcdrun.com ([217.170.207.13]:59895) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1gRptd-0007u6-Q6 for help-gnu-emacs@gnu.org; Tue, 27 Nov 2018 21:48:13 -0500 Original-Received: from protected.rcdrun.com ([::ffff:31.223.149.32]) (AUTH: PLAIN admin, TLS: TLS1.2,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA; Tue, 27 Nov 2018 19:48:11 -0700 id 000000000002070C.000000005BFE01EB.00004BBE Original-Received: from localhost (localhost [127.0.0.1]) (uid 1001) by protected.rcdrun.com with local id 00000000000C8716.000000005BFE01EA.00004372; Wed, 28 Nov 2018 03:48:10 +0100 Content-Disposition: inline In-Reply-To: X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] [fuzzy] X-Received-From: 217.170.207.13 X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.21 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Original-Sender: "help-gnu-emacs" Xref: news.gmane.org gmane.emacs.help:118781 Archived-At: On Mon, Nov 26, 2018 at 10:48:27AM +0100, Martin Steffen wrote: > I encountered a problem with postgres/pg.el after a recent upgrade of > the OS (fedora/postgres). It well might be that pg.el is not the > ``culprit'' but I was not able to properly nail it down and I don't know > how to localize is. > > On a very high level, the problem is: connecting to an existing data base > via pg.el yields the message > > -------------------------- > pg:connect: Backend error: FATAL: unsupported frontend protocol 1.0: server supports 2.0 to 3.0 Hello Martin, I cannot say that this may help you. But I do remember I had similar problem. I am user of PostgreSQL who often installs it myself, not by distribution and I sometimes install one version more than what distribution offers me. So before months I have encountered the same problem. Read more about it here: https://github.com/anse1/emacs-libpq/issues/7 Thus in the version 10 or 10.1 the protocol 1.0 has been dropped. So pg.el does not work any more, unless somebody updates it. My solution was to install that same module libpq which does the work just well since 10 months without problems. https://github.com/anse1/emacs-libpq Packages depending on pg.el may not work. But they can be easily updated or modified. I guess that the more users start using new version of PostgreSQL there will be more reports on how pg.el does not work any more. Jean Louis