Re: Cannot run psql under Cygwin

[Steve Holden <steve at holdenweb 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@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:
> 
> 
> <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