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 <and...@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 <and...@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:pa...@gf.microolap.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers