Search Postgresql Archives

Re: Using native win32 psql.exe using alternative cygwin

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Bill Bartlett wrote:
> I hit this exact same problem, and my initial reaction was the same as
> yours -- psql was "hanging".  After much head-banging, I discovered that
> it is not in fact hanging, but is instead getting confused by being run
> from inside Putty, Cygwin, xterm, rxvt terminal, etc.  Because psql is
> not being run from a native Win32 console window, it puts itself into
> non-interactive mode, so it shows no prompts, allows no line editing,
> shows no command history, etc.  But it is actually running.

Thanks for sharing this insight. Reid Thompson pointed me to
http://www.cygwin.com/ml/cygwin/2003-03/msg01457.html where the cause of
this problem is discussed. It's good to know I can still use 'psql -f
foo.sql' safely under these terminals.

> Alternatively, you can run Cygwin's version of psql against the native
> Win32 PostgreSQL 8 database, assuming you install the base Cygwin
> environment.

I don't like the idea of running a different version of the client and
server, but the thought did cross my mind. I think I'll stick with the
cmd.exe terminal instead (for the time being).

Sincerely,

-- 
Richard van den Berg, CISSP
-------------------------------------------
Trust Factory B.V. |     www.dna-portal.net
Bazarstraat 44a    |  www.trust-factory.com
2518AK The Hague   |  Phone: +31 70 3620684
The Netherlands    |  Fax  : +31 70 3603009
-------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux