Here ( http://www.codelabs.pl/_varia/pg.zip ) is detailed info from my machine (PostgreSQL 8.3.6, compiled by Visual
C++build 1400):
- detailed log file with several memory attach problems - process activity log file (created by Process Monitor from
SysInternals)- dll's loaded by postgres.exe (snapshot only)
Maybe by comparing log entries you will be able to tell smth.
Still there is not much info in the pg log file (my config file in package).
Removing plugin_debugger.dll didn't helped.
> 2009/7/6 Alvaro Herrera <alvherre@commandprompt.com>:
>> Wojciech Strzałka escribió:
>>>
>>> I don't suppose this explains anything but - why not to try (this is
>>> DEBUG and has more details, but looks like some information are less detailed than in
>>> INFO log level ?? (ie. socket error code is missing):
>>
>> I suggest you add %p to log_line_prefix to differentiate log lines for
>> various processes. Also perhaps you want to set log_error_verbosity to
>> VERBOSE to see more details about each message.
>>
>> Since it has been suggested that the problem may be caused by DLLs
>> loaded or not by the processes, I suggest you try to find out which ones
>> are attached to each process, when it works and when it doesn't. Is
>> there a difference?
> Also, try removing the plugin_debugger.dll from
> shared_preload_libraries in postgresql.conf to eliminate that from the
> equation.
--
Pozdrowienia,Wojciech Strzałka