X-Recipient: archive-cygwin AT delorie DOT com
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
To: cygwin AT cygwin DOT com
From: Steve Holden <steve AT holdenweb DOT com>
Subject: Re: Cannot run psql under Cygwin
Date: Wed, 11 Aug 2010 12:42:50 -0400
Lines: 84
Message-ID: <i3ujug$7oe$1@dough.gmane.org>
References: <8C16DEDEF6DE8B418A724B298297A53003F14FCA AT S0-OTT-X3 DOT nrn DOT nrcan DOT gc DOT 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 AT cygwin DOT com; run by ezmlm
Precedence: bulk
List-Id: <cygwin.cygwin.com>
List-Unsubscribe: <mailto:cygwin-unsubscribe-archive-cygwin=delorie DOT com AT cygwin DOT com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com

This is running in a mintty console on a fairly recent (updated four
days ago) Cygwin load and the standard Windows PostgreSQL server:

sholden AT 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 AT 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:
> 
> 
> <http://cygwin.com/cygwin-ug-net/using-cygwinenv.html>
> 
> --
> 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