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>

I wanted to add a comment to this blog entry but it wasn't accepted.
Here it is:

It doesn't work under Wine, see:
http://www.winehq.org/pipermail/wine-users/2013-January/107008.html

But pg_config works so other PostgreSQL clients can also be built using the cross compiler.

>
> 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.
>
> cheers
>
> andrew
>
>
>
>


--
----------------------------------
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/