Hello, Jeff.
You wrote:
JJ> Changed subject from "Strange Windows problem, lock_timeout test request"
JJ> On Thu, Jan 24, 2013 at 11:41 AM, Andrew Dunstan <andrew@dunslane.net> wrote:
JJ> On 01/24/2013 01:44 PM, Jeff Janes wrote:
JJ> On Sat, Jan 19, 2013 at 12:15 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
JJ> On 01/19/2013 02:36 AM, Boszormenyi Zoltan wrote:
JJ> A long time ago I had a lot of sympathy with this answer, but these days not
JJ> so much. Getting a working mingw/msys environment sufficient to build a bare
JJ> bones PostgreSQL from scratch is both cheap and fairly easy. The
JJ> improvements that mingw has made in its install process, and the presence of
JJ> cheap or free windows instances in the cloud combine to make this pretty
JJ> simple. But since it's still slightly involved here is how I constructed
JJ> one such this morning:
JJ> I've used this description, skipping the Amazon part and putting it
JJ> directly on my Windows computer, and it worked.
JJ> Except bin/pg_ctl does not work. It just silently exits without doing
JJ> anything, so I have to use bin/postgres to start the database (which
JJ> is what "make check" uses anyway, so not a problem if you just want
JJ> make check). Is that just me or is that a known problem? I've seen
JJ> some discussion from 2004, but didn't find a conclusion.
JJ> Did you copy libpq.dll from the lib directory to the bin
JJ> directory? If not, try that and see if it fixes the problem.
JJ> I've now done that, and it did fix the problem. I can start the
JJ> database with pg_ctl.exe if I want.
JJ> Should the makefile do this for us? Or is there a way to
JJ> configure so that is not needed (whatever the MinGW equivalent is to an rpath?)
JJ> psql.exe now runs, but it seems to be broken. It hangs forever
JJ> on attempting to connect to any server (either the local one
JJ> compiled with MinGW, or a remote server running on Linux).
JJ> psql on the remote linux machine can connect back to the Windows
JJ> server compiled with MinGW, so the problem seems to be with
JJ> MinGW's psql.exe, not its server.
JJ> Doesn't "make check" have to use something which is morally
JJ> equivalent to psql.exe? If so, how can it pass if psql.exe is broken?
JJ> I've put up a wiki page:
JJ> https://wiki.postgresql.org/wiki/Building_With_MinGW
Jeff, I think inromation about installing dependencies should be added
to this Wiki. At least zlib and openssl are "must have" for libpq, psql and
pg_dump\pg_restore
JJ> Cheers,
JJ> Jeff
--
With best wishes,Pavel mailto:pavel@gf.microolap.com