From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 29379 invoked by alias); 11 Aug 2010 16:43:20 -0000 Received: (qmail 29369 invoked by uid 22791); 11 Aug 2010 16:43:19 -0000 X-SWARE-Spam-Status: Yes, hits=5.1 required=5.0 tests=AWL,BAYES_50,SPF_HELO_PASS,T_RP_MATCHES_RCVD X-Spam-Check-By: sourceware.org Received: from lo.gmane.org (HELO lo.gmane.org) (80.91.229.12) by sourceware.org (qpsmtpd/0.43rc1) with ESMTP; Wed, 11 Aug 2010 16:43:15 +0000 Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1OjEOS-00069I-Uj for cygwin@cygwin.com; Wed, 11 Aug 2010 18:43:08 +0200 Received: from pool-108-56-171-244.washdc.fios.verizon.net ([108.56.171.244]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 11 Aug 2010 18:43:08 +0200 Received: from steve by pool-108-56-171-244.washdc.fios.verizon.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 11 Aug 2010 18:43:08 +0200 To: cygwin@cygwin.com From: Steve Holden Subject: Re: Cannot run psql under Cygwin Date: Wed, 11 Aug 2010 16:43:00 -0000 Message-ID: References: <8C16DEDEF6DE8B418A724B298297A53003F14FCA@S0-OTT-X3.nrn.nrcan.gc.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2.8) Gecko/20100802 Thunderbird/3.1.2 In-Reply-To: <8C16DEDEF6DE8B418A724B298297A53003F14FCA@S0-OTT-X3.nrn.nrcan.gc.ca> X-IsSubscribed: yes Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm Precedence: bulk List-Id: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner@cygwin.com Mail-Followup-To: cygwin@cygwin.com X-SW-Source: 2010-08/txt/msg00259.txt.bz2 This is running in a mintty console on a fairly recent (updated four days ago) Cygwin load and the standard Windows PostgreSQL server: sholden@lifeboy ~/Projects/PytDj/Pyteach/templates/training $ psql -h localhost -p 5432 -U django PyTeach Password for user django: Welcome to psql 8.2.11 (server 8.3.5), the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit WARNING: You are connected to a server with major version 8.3, but your psql client is major version 8.2. Some backslash commands, such as \d, might not work properly. PyTeach=> select * from city; id | ctyname ----+------------------- 2 | Washington, DC 6 | New York, NY 7 | London, England 8 | Boston, MA 9 | Chicago, IL 10 | Atlanta, GA 11 | Los Angeles, CA 12 | San Francisco, CA (8 rows) PyTeach=> \q sholden@lifeboy ~/Projects/PytDj/Pyteach/templates/training $ which psql /usr/bin/psql Had you considered using the Cygwin psql rather than the Windows one? regards Steve On 8/11/2010 12:23 PM, Clement, Sebastien wrote: > Okay, many thanks Larry. > > I forgot to mention I was using the MinTTY console. > It works when I use the regular Cygwin console. > > I found that: > http://cygwin.com/ml/cygwin/2009-10/msg00330.html > > > Sébastien > ------ > > > > On 8/11/2010 11:57 AM, Clement, Sebastien wrote: > > When I try to run psql (eg. psql -U myusername -d mydb) from Cygwin, it freezes. > When I run it from the DOS console, it works fine. > > > In that case, you need to run Cygwin's bash from a console (i.e. use > 'cygwin.bat' as provided by 'setup.exe') and run 'psql' from there. > See the 'tty' option for the CYGWIN environment variable in the Users > Guide for more details: > > > > > -- > Larry Hall http://www.rfk.com > RFK Partners, Inc. (508) 893-9779 - RFK Office > 216 Dalton Rd. (508) 893-9889 - FAX > Holliston, MA 01746 > -- Steve Holden +1 571 484 6266 +1 800 494 3119 DjangoCon US September 7-9, 2010 http://djangocon.us/ See Python Video! http://python.mirocommunity.org/ Holden Web LLC http://www.holdenweb.com/ -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple