This is running in a mintty console on a fairly recent (updated four
days ago) Cygwin load and the standard Windows PostgreSQL server:
shol...@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
shol...@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
