From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Andreas Seltenreich Newsgroups: gmane.emacs.help,gmane.comp.db.postgresql.general Subject: Re: failure to connect to postgres DB via pg.el Date: Sat, 07 Oct 2006 13:54:41 +0200 Message-ID: <874pugqr26.fsf@gate450.dyndns.org> References: NNTP-Posting-Host: main.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: sea.gmane.org 1160222113 7258 80.91.229.2 (7 Oct 2006 11:55:13 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Sat, 7 Oct 2006 11:55:13 +0000 (UTC) Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Sat Oct 07 13:55:11 2006 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by ciao.gmane.org with esmtp (Exim 4.43) id 1GWAlk-00011a-9Z for geh-help-gnu-emacs@m.gmane.org; Sat, 07 Oct 2006 13:55:04 +0200 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1GWAlj-0000Wk-Q4 for geh-help-gnu-emacs@m.gmane.org; Sat, 07 Oct 2006 07:55:03 -0400 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1GWAlU-0000VC-M4 for help-gnu-emacs@gnu.org; Sat, 07 Oct 2006 07:54:48 -0400 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1GWAlS-0000T9-OT for help-gnu-emacs@gnu.org; Sat, 07 Oct 2006 07:54:48 -0400 Original-Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1GWAlS-0000Sx-KB for help-gnu-emacs@gnu.org; Sat, 07 Oct 2006 07:54:46 -0400 Original-Received: from [129.13.185.218] (helo=smtp2.rz.uni-karlsruhe.de) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA:32) (Exim 4.52) id 1GWAsY-0001nQ-AA for help-gnu-emacs@gnu.org; Sat, 07 Oct 2006 08:02:06 -0400 Original-Received: from rzstud2.stud.uni-karlsruhe.de (exim@rzstud2.stud.uni-karlsruhe.de [193.196.41.38]) by smtp2.rz.uni-karlsruhe.de with esmtp (Exim 4.50 #1) id 1GWAlP-0008VU-55; Sat, 07 Oct 2006 13:54:43 +0200 Original-Received: from uwi7 by rzstud2.stud.uni-karlsruhe.de with local (Exim 4.43) id 1GWAlO-0001dk-PF; Sat, 07 Oct 2006 13:54:42 +0200 Original-To: help-gnu-emacs@gnu.org, pgsql-general@postgresql.org X-Face: $:F<87a[gD1?#R6S3j21cr1&C&7bd63GHC.tSdskUb}hhwG(ci*=D5kJ<_N+p9q(7-, PnG. Et.Yh (Martin Steffen's message of "07 Oct 2006 12\:14\:00 +0200") User-Agent: Gnus/5.110006 (No Gnus v0.6) Emacs/22.0.50 (gnu/linux) X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:37878 gmane.comp.db.postgresql.general:77765 Archived-At: Martin Steffen writes: > worked fine for some years, only that when I changed recently to a new > linux distribution (from Suse 10 to the latest Fedora core), things broke. [...] > - or postgres applies tougher access restrictions on > the new linux distribution, and therefore rejects me > > What is strange, however, is that I can access the > running data base as "user-name" using the command-line > tool psql just fine, without being rejected. [...] > signal(error ("Backend error: FATAL: Ident authentication failed for user \"user-name\"\n")) Since pg.el only supports connections via tcp, a possible explanation of psql's differing behavior could be that pg_hba.conf specifies different authentication methods for unix domain and network sockets. E.g., while SuSE used the "trust" method for local tcp connections, Fedora might be using the "ident" method. The pg_hba.conf file is documented here: regards, andreas