Cannot run psql under Cygwin
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. Here are the versions on my system: Windows XP Pro 2002, Service Pack 3 Cygwin: CYGWIN_NT-5.1 W-QUE-A103212 1.7.5(0.225/5/3) 2010-04-12 19:07 i686 Cygwin PostgreSQL: 8.4.4 No version of PostgreSQL was installed under Cygwin. Sébastien Clément -- 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
Re: Cannot run psql under Cygwin
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 _ A: Yes. Q: Are you sure? A: Because it reverses the logical flow of conversation. Q: Why is top posting annoying in email? -- 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
Re: Cannot run psql under Cygwin
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 -- 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
Re: Cannot run psql under Cygwin
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, 2010http://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