Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition
Hi guys,It is strange but after I gave postmaster.exe process access to the Internet (changed my personal firewall settings), PostgreSQL service starts OK. Why does postmaster.exe need access to the Internet? LeonidOn 11/3/06, Leonid Shlyapnikov <[EMAIL PROTECTED]> wrote: Hi everyone!Harald, my data\ directory does not contain pg_log\ directory, here is my data\ dir content:> C:\Program Files\PostgreSQL\8.1\data>dir /bbaseglobalpg_clogpg_hba.confpg_ident.conf pg_multixactpg_subtranspg_tblspcpg_twophasePG_VERSIONpg_xlogpostgresql.confRegards,Leonid On 11/3/06, Harald Armin Massa <[EMAIL PROTECTED]> wrote: Leonid,System Event Viewer has the follwoing entries:1. The PostgreSQL Database Server 8.1 service was successfully sent a startcontrol.2. The PostgreSQL Database Server 8.1 service entered the running state.3. The PostgreSQL Database Server 8.1 service entered the stopped state. please look inside your PostgreSQL data directory. There should be a directory named pg_logWithin that directory there are log files. Please check them for information, post them to this list.Harald -- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607-Python: the only language with more web frameworks than keywords.
[BUGS] BUG #2735: DEBUG: Error 2769: Custom Action GetAvailableLocales did not close 1 MSIHANDLEs
The following bug has been logged online:
Bug reference: 2735
Logged by: Emil J.
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.5, 8.1.4
Operating system: Windows XP Pro SP2
Description:DEBUG: Error 2769: Custom Action GetAvailableLocales
did not close 1 MSIHANDLEs
Details:
When i run postgresql-8.1.msi, "Welcome" window appear. I click on "Start"
button. Nothing happened.
I read this: http://www.postgresql.org/docs/faqs.FAQ_windows.html#3.1
I don't have antivir, don't have firewall.
This is log:
=== Verbose logging started: 4.11.2006 10:43:38 Build type: SHIP UNICODE
3.01.4000.2435 Calling process: C:\WINDOWS\system32\msiexec.exe ===
MSI (c) (EC:2C) [10:43:38:015]: Resetting cached policy values
MSI (c) (EC:2C) [10:43:38:015]: Machine policy value 'Debug' is 0
MSI (c) (EC:2C) [10:43:38:015]: *** RunEngine:
*** Product:
T:\_WebInstall_\postgresql-8.1.5-1\postgresql-8.1-int.msi
*** Action:
*** CommandLine: **
MSI (c) (EC:2C) [10:43:38:437]: Machine policy value 'DisableUserInstalls'
is 0
MSI (c) (EC:2C) [10:43:39:437]: SOFTWARE RESTRICTION POLICY: Verifying
package --> 'T:\_WebInstall_\postgresql-8.1.5-1\postgresql-8.1-int.msi'
against software restriction policy
MSI (c) (EC:2C) [10:43:39:437]: Note: 1: 2262 2: DigitalSignature 3:
-2147287038
MSI (c) (EC:2C) [10:43:39:437]: SOFTWARE RESTRICTION POLICY:
T:\_WebInstall_\postgresql-8.1.5-1\postgresql-8.1-int.msi is not digitally
signed
MSI (c) (EC:2C) [10:43:39:437]: SOFTWARE RESTRICTION POLICY:
T:\_WebInstall_\postgresql-8.1.5-1\postgresql-8.1-int.msi is permitted to
run at the 'unrestricted' authorization level.
MSI (c) (EC:2C) [10:43:39:453]: Cloaking enabled.
MSI (c) (EC:2C) [10:43:39:453]: Attempting to enable all disabled priveleges
before calling Install on Server
MSI (c) (EC:2C) [10:43:39:468]: End dialog not enabled
MSI (c) (EC:2C) [10:43:39:468]: Original package ==>
T:\_WebInstall_\postgresql-8.1.5-1\postgresql-8.1-int.msi
MSI (c) (EC:2C) [10:43:39:468]: Package we're running from ==>
D:\Temp\6329b.msi
MSI (c) (EC:2C) [10:43:39:484]: APPCOMPAT: looking for appcompat database
entry with ProductCode '{34D95765-2D5A-470F-A39F-BC9DEAAAF04F}'.
MSI (c) (EC:2C) [10:43:39:484]: APPCOMPAT: no matching ProductCode found in
database.
MSI (c) (EC:2C) [10:43:39:484]: MSCOREE not loaded loading copy from
system32
MSI (c) (EC:2C) [10:43:39:484]: Machine policy value 'TransformsSecure' is
0
MSI (c) (EC:2C) [10:43:39:484]: User policy value 'TransformsAtSource' is 0
MSI (c) (EC:2C) [10:43:39:484]: Machine policy value 'DisablePatch' is 0
MSI (c) (EC:2C) [10:43:39:484]: Machine policy value 'AllowLockdownPatch' is
0
MSI (c) (EC:2C) [10:43:39:484]: Machine policy value 'DisableLUAPatching' is
0
MSI (c) (EC:2C) [10:43:39:484]: Machine policy value
'DisableFlyWeightPatching' is 0
MSI (c) (EC:2C) [10:43:39:484]: APPCOMPAT: looking for appcompat database
entry with ProductCode '{34D95765-2D5A-470F-A39F-BC9DEAAAF04F}'.
MSI (c) (EC:2C) [10:43:39:484]: APPCOMPAT: no matching ProductCode found in
database.
MSI (c) (EC:2C) [10:43:39:484]: Transforms are not secure.
MSI (c) (EC:2C) [10:43:39:484]: Command Line: INTERNALLAUNCH=1
CURRENTDIRECTORY=C:\WINDOWS\system32 CLIENTUILEVEL=0 CLIENTPROCESSID=2028
MSI (c) (EC:2C) [10:43:39:484]: PROPERTY CHANGE: Adding PackageCode
property. Its value is '{41F587DD-BEA3-4597-BFE1-5CB379507A4D}'.
MSI (c) (EC:2C) [10:43:39:484]: Product Code passed to Engine.Initialize:
''
MSI (c) (EC:2C) [10:43:39:484]: Product Code from property table before
transforms: '{34D95765-2D5A-470F-A39F-BC9DEAAAF04F}'
MSI (c) (EC:2C) [10:43:39:484]: Product Code from property table after
transforms: '{34D95765-2D5A-470F-A39F-BC9DEAAAF04F}'
MSI (c) (EC:2C) [10:43:39:484]: Product not registered: beginning first-time
install
MSI (c) (EC:2C) [10:43:39:484]: PROPERTY CHANGE: Adding ProductState
property. Its value is '-1'.
MSI (c) (EC:2C) [10:43:39:484]: Entering
CMsiConfigurationManager::SetLastUsedSource.
MSI (c) (EC:2C) [10:43:39:484]: User policy value 'SearchOrder' is 'nmu'
MSI (c) (EC:2C) [10:43:39:484]: Adding new sources is allowed.
MSI (c) (EC:2C) [10:43:39:484]: PROPERTY CHANGE: Adding PackagecodeChanging
property. Its value is '1'.
MSI (c) (EC:2C) [10:43:39:484]: Package name extracted from package path:
'postgresql-8.1-int.msi'
MSI (c) (EC:2C) [10:43:39:484]: Package to be registered:
'postgresql-8.1-int.msi'
MSI (c) (EC:2C) [10:43:39:484]: Note: 1: 2205 2: 3: Error
MSI (c) (EC:2C) [10:43:39:484]: Note: 1: 2729
MSI (c) (EC:2C) [10:43:39:484]: Note: 1: 2729
MSI (c) (EC:2C) [10:43:39:484]: Note: 1: 2729
MSI (c) (EC:2C) [10:43:39:484]: Note: 1: 2729
MSI (c) (EC:2C) [10:43:39:484]: Note: 1: 2729
MSI (c) (EC:2C) [10:43:39:500]: Note: 1: 2729
MSI (c) (EC:2C) [10:43:39:500]: Note: 1: 2729
MSI (c) (EC:2C) [10:43:39:500]: Note: 1: 2729
MSI (c) (EC:2C) [10:43:39:500]: Note: 1: 2729
MSI (c) (EC:2C) [10:43:39:500]: Note: 1: 2729
MSI (c) (EC
Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition
Harald,I agree... but where is a descriptive message in the log.Thanks,LeonidOn 11/4/06, Harald Armin Massa < [EMAIL PROTECTED]> wrote:Leonid, It is strange but after I gave postmaster.exe process access to the Internet (changed my personal firewall settings), PostgreSQL service starts OK. Why does postmaster.exe need access to the Internet?PostgreSQL / postmaster.exe do not need to connect to the Internet. But communication is done via TCP/IP; and PostgreSQL needs to open Port 5432 (standard) and listen for requests. So when your firewall forbids PostgreSQL to listen on Port 5433 for incoming requests, it may commit suicide, because it cannot do any usefull work anymore. Best wishes,Harald-- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart 0173/9409607-Python: the only language with more web frameworks than keywords.
Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition
Hi everyone!Harald, my data\ directory does not contain pg_log\ directory, here is my data\ dir content:> C:\Program Files\PostgreSQL\8.1\data>dir /bbaseglobalpg_clogpg_hba.confpg_ident.conf pg_multixactpg_subtranspg_tblspcpg_twophasePG_VERSIONpg_xlogpostgresql.confRegards,LeonidOn 11/3/06, Harald Armin Massa <[EMAIL PROTECTED]> wrote: Leonid,System Event Viewer has the follwoing entries:1. The PostgreSQL Database Server 8.1 service was successfully sent a startcontrol.2. The PostgreSQL Database Server 8.1 service entered the running state.3. The PostgreSQL Database Server 8.1 service entered the stopped state. please look inside your PostgreSQL data directory. There should be a directory named pg_logWithin that directory there are log files. Please check them for information, post them to this list.Harald -- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607-Python: the only language with more web frameworks than keywords.
Re: [BUGS] 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio
Tom Lane wrote: Andreas Lange <[EMAIL PROTECTED]> writes: Tom Lane wrote: I suppose there is something funny about pow() on your platform causing that probe to fail. What does config.log have at the "checking for library containing pow" step? configure:5168: checking for library containing pow configure:5198: /sw/sun-studio-11/SUNWspro/bin/cc -Xa -o conftest -fast -fns=no -fsimple=1 -xtarget=opteron -xarch=amd64a conftest.c >&5 configure:5204: $? = 0 configure:5208: test -z || test ! -s conftest.err configure:5211: $? = 0 configure:5214: test -s conftest configure:5217: $? = 0 configure:5287: result: none required Interesting. Could pow() actually be in libc on your machine? The other possible explanation is that it's a macro, but the AC_SEARCH_LIBS code seems to go out of its way to fail if that's the case. Anyway this illustrates the dilemma we face in trying to do a real probe for libm: the common functions (pow) are likely to be macro-ized, while uncommon ones might not be there at all (cbrt). Anyone have a better idea than reverting to the unconditional AC_CHECK_LIB(m, main) call? Main problem is -fast switch. It modifies behavior of floating point operation (it is reason why It is not good option for postgres) and use another floating point libraries and some function are inlined. It is reason why pow test passed with -fast switch without -lm switch. Detail description of -fast you can found on http://docs.sun.com/source/819-3688/cc_ops.app.html Zdenek ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP
Windows has another bug; they don't include a proper loopback function
with the standard distribution _and_ they have some asenine view that if
there's no physical network connection available, they tear down the
network stack! This means that anything that connects with TCP/IP can't
work, even if it's to the local machine. I consider this idiocy, but,
there's windows for you in a nutshell...
However, you _can_ find a proper "loopback driver", I think they call it -
software, of course. Also, I carry in my laptop case a special HARDWARE
loopback connector! It's an RJ45 that has the wires crossed over. I use it
when I'm at a customer site or otherwise "away from home" and my customer
doesn't have the software loopback - plug my loopback connector into any
"twisted pair ethernet" socket and suddenly the TCP/IP software works
fine!
there is a loopback driver shipped with windows xp / windows 2003. but you
have to add it manually ("add hardwar"e --> "add a new hardware device" -->
"select from a list" --> "show all devices" --> "microsoft" --> "Microsoft
Loopback Adapter")
cheers,
thomas
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP
On Sat, 4 Nov 2006, Harald Armin Massa wrote: > > Leonid, > > It is strange but after I gave postmaster.exe process access to the Internet > > (changed my personal firewall settings), PostgreSQL service starts OK. Why > > does postmaster.exe need access to the Internet? > > > > PostgreSQL / postmaster.exe do not need to connect to the Internet. But > communication is done via TCP/IP; and PostgreSQL needs to open Port 5432 > (standard) and listen for requests. So when your firewall forbids PostgreSQL > to listen on Port 5433 for incoming requests, it may commit suicide, because > it cannot do any usefull work anymore. > > Best wishes, > > Harald Windows has another bug; they don't include a proper loopback function with the standard distribution _and_ they have some asenine view that if there's no physical network connection available, they tear down the network stack! This means that anything that connects with TCP/IP can't work, even if it's to the local machine. I consider this idiocy, but, there's windows for you in a nutshell... However, you _can_ find a proper "loopback driver", I think they call it - software, of course. Also, I carry in my laptop case a special HARDWARE loopback connector! It's an RJ45 that has the wires crossed over. I use it when I'm at a customer site or otherwise "away from home" and my customer doesn't have the software loopback - plug my loopback connector into any "twisted pair ethernet" socket and suddenly the TCP/IP software works fine! Oh the joys of dealing with Windows. Richard P.S. You can't get one of these RJ45 loopback connectors commercially, I don't think, but I can send you directions - or make one for you if you send me a tenner! -smile- RT -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition
Leonid,I agree... but where is a descriptive message in the log. a healthy:) data directory looks like this:baseglobalpg_clogpg_hba.confpg_ident.confpg_logpg_multixactpg_subtranspg_tblspcpg_twophasePG_VERSIONpg_xlogpostgresql.conf postmaster.optspostmaster.pidand within pg_log there are log filesI think that those lines:#---# ERROR REPORTING AND LOGGING #---# - Where to Log -log_destination = 'stderr' # Valid values are combinations of # stderr, syslog and eventlog, # depending on platform.# This is used when logging to stderr:redirect_stderr = on # Enable capturing of stderr into log # files# These are only used if redirect_stderr is on: #log_directory = 'pg_log' # Directory where log files are written # Can be absolute or relative to PGDATAwithin my postgresql-config (last one is a default) are responsible for this. Did you change the logging directory? Best wishes,Harald-- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607-Python: the only language with more web frameworks than keywords.
Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition
Leonid,It is strange but after I gave postmaster.exe process access to the Internet (changed my personal firewall settings), PostgreSQL service starts OK. Why does postmaster.exe need access to the Internet?PostgreSQL / postmaster.exe do not need to connect to the Internet. But communication is done via TCP/IP; and PostgreSQL needs to open Port 5432 (standard) and listen for requests. So when your firewall forbids PostgreSQL to listen on Port 5433 for incoming requests, it may commit suicide, because it cannot do any usefull work anymore. Best wishes,Harald-- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607-Python: the only language with more web frameworks than keywords.
