From: Steve Holden <steve@holdenweb.com>
To: cygwin@cygwin.com
Subject: Re: Cannot run psql under Cygwin
Date: Wed, 11 Aug 2010 16:43:00 -0000 [thread overview]
Message-ID: <i3ujug$7oe$1@dough.gmane.org> (raw)
In-Reply-To: <8C16DEDEF6DE8B418A724B298297A53003F14FCA@S0-OTT-X3.nrn.nrcan.gc.ca>
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
next prev parent reply other threads:[~2010-08-11 16:43 UTC|newest]
Thread overview: 4+ messages / expand[flat|nested] mbox.gz Atom feed top
2010-08-11 16:23 Clement, Sebastien
2010-08-11 16:43 ` Steve Holden [this message]
-- strict thread matches above, loose matches on Subject: below --
2010-08-11 15:57 Clement, Sebastien
2010-08-11 16:09 ` Larry Hall (Cygwin)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to='i3ujug$7oe$1@dough.gmane.org' \
--to=steve@holdenweb.com \
--cc=cygwin@cygwin.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).