From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Pascal c Newsgroups: gmane.emacs.help Subject: Re: Emacs + sql-postgres Date: Wed, 29 May 2013 11:56:11 +0200 Message-ID: References: <86ip229nt7.fsf@w2139spb.ru.yotateam.com> NNTP-Posting-Host: plane.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Trace: ger.gmane.org 1369821443 14093 80.91.229.3 (29 May 2013 09:57:23 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Wed, 29 May 2013 09:57:23 +0000 (UTC) To: help-gnu-emacs Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Wed May 29 11:57:21 2013 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([208.118.235.17]) by plane.gmane.org with esmtp (Exim 4.69) (envelope-from ) id 1Uhd8B-0007Pd-Rk for geh-help-gnu-emacs@m.gmane.org; Wed, 29 May 2013 11:57:19 +0200 Original-Received: from localhost ([::1]:59449 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Uhd8B-0006rW-In for geh-help-gnu-emacs@m.gmane.org; Wed, 29 May 2013 05:57:19 -0400 Original-Received: from eggs.gnu.org ([208.118.235.92]:55339) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Uhd7E-0005sZ-4a for help-gnu-emacs@gnu.org; Wed, 29 May 2013 05:56:26 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Uhd77-0002fq-2K for help-gnu-emacs@gnu.org; Wed, 29 May 2013 05:56:19 -0400 Original-Received: from mail-pb0-x22c.google.com ([2607:f8b0:400e:c01::22c]:53381) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Uhd76-0002fg-T2 for help-gnu-emacs@gnu.org; Wed, 29 May 2013 05:56:13 -0400 Original-Received: by mail-pb0-f44.google.com with SMTP id wz12so9019064pbc.17 for ; Wed, 29 May 2013 02:56:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=NgsCTSO/1W+VQoUnLwO00mv3uoL/gzazoG2+4w8uXjE=; b=U9dKLan4aK3SehpAFeEX8p9HCfkk0oHgEDEJr7DVtS0T6accXdyqUq1PC5YROpd8Ef zlgANKeTsAGYkWQgvjgVN2EtEwHa601yC1JhC+5FaoaNltU6zisUFHS9qbSLfFNrYAMa WvS83mijqaDDWHDqjTzwLzUCcew6IurzXxaocbr7ug/LxWTZfq4pQqwdaOXrcSRSyRil W4UV949pPD8OctEjGtw6SL+mRGxzMdpqjiUC1OA/57YTi2zZtIqwY0IoXKq4n0Qslzgd UHacSRfuEQPqjVsPHH7iHEnFh64RwBtuw15b9bcJ+1g1mLagQJgeorv7e0wzAQX0V1il /b0g== X-Received: by 10.66.51.102 with SMTP id j6mr2441822pao.210.1369821372014; Wed, 29 May 2013 02:56:12 -0700 (PDT) Original-Received: by 10.68.125.199 with HTTP; Wed, 29 May 2013 02:56:11 -0700 (PDT) In-Reply-To: <86ip229nt7.fsf@w2139spb.ru.yotateam.com> X-detected-operating-system: by eggs.gnu.org: Error: Malformed IPv6 address (bad octet value). X-Received-From: 2607:f8b0:400e:c01::22c X-Content-Filtered-By: Mailman/MimeDel 2.1.14 X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.14 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-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:91125 Archived-At: hi Filipp, thank you for your reply. As you can read into my email I'm using psql from cygwin : >Password for user postgres: >psql: FATAL: Passwort-Authentifizierung f=C2=B3r Benutzer =E2=95=97 postg= res=C2=BD fehlgeschlagen >Into my .emacs I have written the line : >(setq sql-postgres-program "C:\\cygwin\\bin\\psql.exe") or mybe this is not the psql from cygwin ? Thank you, Cheers, Pascal 2013/5/29 Filipp Gunbin > On 29/05/2013 11:22 +0400, Pascal c wrote: > > > If I use sql-postgres, I got the prompt to entry my user, host and > database. > > Then I got the prompt from psql to entry my password. But this doesn't > > work. > > I got the following state : > > > > Password for user postgres: > > psql: FATAL: Passwort-Authentifizierung f=C2=B3r Benutzer =E2=95=97 po= stgres=C2=BD > > fehlgeschlagen > > The simplest case is using cygwin Postgres (with psql) from cygwin > Emacs. Try that, if that does not work then probably you have some > authentication problems. > > As for issuing commands, you can do that either from interactive sql > buffer, which runs psql and therefore accepts its commands, or from any > sql buffer which have an associated interactive buffer (then commands > like `C-c C-r' for sending a query to the interactive buffer apply). > > `sql-set-sqli-buffer' allows to choose such an interactive buffer. > `sql-set-product' with an argument of `sql-postgres' may be required > before `sql-set-sqli-buffer'. > > Filipp >