Re: Strange Windows problem, lock_timeout test request

2013-01-19 01:13 keltezéssel, Andrew Dunstan írta:
>
> On 01/18/2013 05:43 PM, Boszormenyi Zoltan wrote:
>> Hi,
>>
>> using the MinGW cross-compiled PostgreSQL binaries from Fedora 18,
>> I get the following error for both 32 and 64-bit compiled executables.
>> listen_addresses = '*' and "trust" authentication was set for both.
>> The firewall was disabled for the tests and the server logs "incomplete startup packet".
>> The 64-bit version was compiled with my lock_timeout patch, the 32-bit
>> was without.
>>
>> 64-bit, connect to localhost:
>>
>> C:\Users\Ákos\Desktop\PG93>bin\psql
>> psql: could not connect to server: Operation would block (0x00002733/10035)
>>         Is the server running on host "localhost" (::1) and accepting
>>         TCP/IP connections on port 5432?
>> could not connect to server: Operation would block (0x00002733/10035)
>>         Is the server running on host "localhost" (127.0.0.1) and accepting
>>         TCP/IP connections on port 5432?
>>
>> 64-bit, connect to own IP:
>>
>> C:\Users\Ákos\Desktop\PG93>bin\psql -h 192.168.1.4
>> psql: could not connect to server: Operation would block (0x00002733/10035)
>>         Is the server running on host "192.168.1.4" and accepting
>>         TCP/IP connections on port 5432?
>>
>> 32-bit, connect to own IP:
>>
>> C:\Users\Ákos\Desktop\PG93-32>bin\psql -h 192.168.1.4
>> psql: could not connect to server: Operation would block (0x00002733/10035)
>>         Is the server running on host "192.168.1.4" and accepting
>>         TCP/IP connections on port 5432?
>>
>> Does it ring a bell for someone?
>>
>> Unfortunately, I won't have time to do anything with my lock_timeout patch
>> for about 3 weeks. Does anyone have a little spare time to test it on Windows?
>> The patch is here, it still applies to HEAD without rejects or fuzz:
>> http://www.postgresql.org/message-id/506C0854.7090008@cybertec.at
>
> Yes it rings a bell. See
> <http://people.planetpostgresql.org/andrew/index.php?/archives/264-Cross-compiling-PostgreSQL-for-WIndows.html>

The strange thing is that I have used cross-compiled build
during Fedora 16 prime time (using the mingw-w64 test repository) and
early Fedora 17 using the mingw32-* and ming64-* GCC packages
that were pulled from the above mentioned repository. It was the last time
I tested PG on Windows and it worked. I could connect to it both locally
and from my Linux PC.

>
> Cross-compiling is not really a supported platform. Why don't you just build natively?
> This is know to work as shown by the buildfarm animals doing it successfully.

Because I don't have a mingw setup on Windows. (Sorry.)

--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de     http://www.postgresql.at/