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. (And I
couldn't find any combination of TERM settings, security settings or any
other settings that would get around this.)
Unfortunately, at the moment there is no command-line flag to force psql
into "interactive" mode. I have the code (courtesy of Bruce Momjian) to
add a flag such as this, but I haven't had time to set up the
environment to actually recompile psql.
Alternatively, you can run Cygwin's version of psql against the native
Win32 PostgreSQL 8 database, assuming you install the base Cygwin
environment. This does work fine, and gives you the added benefit of
including "readline" support (something compiled out of the native Win32
version of psql), so tab-completion works even in the Windows
environment. Two caveats, however:
1) You can't install _just_ psql from the Cygwin setup -- you'll have to
install the complete PostgreSQL environment (database and all), then
copy just the psql-related files (psql.exe and pq.dll) to your
workstation. (So be sure to NOT install this on your main PostgreSQL
server -- no telling what will happen when the Cygwin version of the
PostgreSQL server tries to run at the same time as the native Win32
version already on there.)
2) The latest "release" version of PostgreSQL for Cygwin is v7.4.5.
There is v8.x code available in CVS, but you'll have to compile it
yourself. I'm also planning on doing this too, but I haven't had the
time.
- Bill
as info -- if you use the cygwin setup program, and click the
Exp(erimental) tab, you'll get 8.0.0-cvs downloaded/installed.
You can check the box to download the source also/instead, if you want
to build yourself....
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
