Обсуждение: Installation Error, Server Won't Start
I downloaded the 8.3 exe for Windows (XP) and started the installation. When it got near the end, a warning window opened stating "Problem running post-install step. Installation may not complete correctly. Failed to start the database server." When I openned the pgadmin, the server pane showed "Servers(0)". I tried to add server where Host = localhost, but I get "Server Doesn't Listen". I would appreciate any suggests on how to better prepare and execute an installation. Thaks, ray
On 18/03/2009 21:10, ray wrote: > I downloaded the 8.3 exe for Windows (XP) and started the > installation. When it got near the end, a warning window opened > stating "Problem running post-install step. Installation may not > complete correctly. Failed to start the database server." Did you select the option to log the installation? If you didn't, uninstall if you can, then try it again, and if it still doesn't work post the log here (or at least the bits showing errors). Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
On Mar 18, 5:07 pm, r...@iol.ie ("Raymond O'Donnell") wrote: > On 18/03/2009 21:10, ray wrote: > > > I downloaded the 8.3 exe for Windows (XP) and started the > > installation. When it got near the end, a warning window opened > > stating "Problem running post-install step. Installation may not > > complete correctly. Failed to start the database server." > > Did you select the option to log the installation? If you didn't, > uninstall if you can, then try it again, and if it still doesn't work > post the log here (or at least the bits showing errors). > > Ray. > > ------------------------------------------------------------------ > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland > r...@iol.ie > Galway Cathedral Recitals:http://www.galwaycathedral.org/recitals > ------------------------------------------------------------------ > Raymond, I do not see an opportunity to request a log to be written. From the Psotgre site, I downloaded: postgresql-8.3.7-1-windows.exe There isn't an entry in the Control Panel to remove PostgreSQL. When I rerun the installation, it detects that there is an existing one and says it will update. Then it asked what I want to do with some of the conflicts (which I said "Ignore"). Ray
On 18/03/2009 22:22, ray wrote: > I do not see an opportunity to request a log to be written. From the > Psotgre site, I downloaded: > postgresql-8.3.7-1-windows.exe Ah, I see - that's the one-click installer, which is maintained by EnterpriseDB. I haven't used that one; I was thinking of the community installer (pgInstaller), and that's the one has the logging option. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
On Mar 19, 2:04 pm, r...@iol.ie ("Raymond O'Donnell") wrote: > On 18/03/2009 22:22, ray wrote: > > > I do not see an opportunity to request a log to be written. From the > > Psotgre site, I downloaded: > > postgresql-8.3.7-1-windows.exe > > Ah, I see - that's the one-click installer, which is maintained by > EnterpriseDB. I haven't used that one; I was thinking of the community > installer (pgInstaller), and that's the one has the logging option. > > Ray. > > ------------------------------------------------------------------ > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland > r...@iol.ie > Galway Cathedral Recitals:http://www.galwaycathedral.org/recitals > ------------------------------------------------------------------ > > -- > Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org) > To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general Raymond, The pgInstaller does more (I don't know what) such that I now get an entry on the start menu and the Control Panel Add/Remove listing. However, this install did not work either. When it tried to start the db, it couldn't and then stated that the process failed and then started backing out files. It did leave a log file. When I went to Control Panel to remove it, a window stated that it must have already been removed and asked if I wanted to just remove it from the Control Panel listed which I did. After looking at the log file, I saw that it was reaching into my Local \Internet\temp folder to get things. So I cleaned this out and will try to start again and if there are still problems, I will post portions of the log. Thanks, Ray
On Mar 19, 2:04 pm, r...@iol.ie ("Raymond O'Donnell") wrote: > On 18/03/2009 22:22, ray wrote: > > > I do not see an opportunity to request a log to be written. From the > > Psotgre site, I downloaded: > > postgresql-8.3.7-1-windows.exe > > Ah, I see - that's the one-click installer, which is maintained by > EnterpriseDB. I haven't used that one; I was thinking of the community > installer (pgInstaller), and that's the one has the logging option. > > Ray. > > ------------------------------------------------------------------ > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland > r...@iol.ie > Galway Cathedral Recitals:http://www.galwaycathedral.org/recitals > ------------------------------------------------------------------ > > -- > Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org) > To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general Raymond, I have tried it again with system changes I thought might help but there was no change in the response. I have included some sections for the log, below. The last warning message was: Service 'PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start. Verify that you have sufficient privileges to start system services. Since I can use a variety of system applications that start/stop enable/automate/manual any of the system services so I don't think it is a rights issue. Here is the first part of the log: === Verbose logging started: 3/19/2009 14:48:13 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:\WINDOWS \system32\msiexec.exe === MSI (c) (88:90) [14:48:13:707]: Resetting cached policy values MSI (c) (88:90) [14:48:13:707]: Machine policy value 'Debug' is 0 MSI (c) (88:90) [14:48:13:707]: ******* RunEngine: ******* Product: C:\PostgreSQL\8.3.7\temp\postgresql-8.3- int.msi ******* Action: ******* CommandLine: ********** MSI (c) (88:90) [14:48:13:707]: Machine policy value 'DisableUserInstalls' is 0 MSI (c) (88:90) [14:48:18:314]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'C:\PostgreSQL\8.3.7\temp\postgresql-8.3-int.msi' against software restriction policy MSI (c) (88:90) [14:48:18:314]: Note: 1: 2262 2: DigitalSignature 3: -2147287038 MSI (c) (88:90) [14:48:18:314]: SOFTWARE RESTRICTION POLICY: C: \PostgreSQL\8.3.7\temp\postgresql-8.3-int.msi is not digitally signed MSI (c) (88:90) [14:48:18:330]: SOFTWARE RESTRICTION POLICY: C: \PostgreSQL\8.3.7\temp\postgresql-8.3-int.msi is permitted to run at the 'unrestricted' authorization level. MSI (c) (88:90) [14:48:18:408]: Cloaking enabled. MSI (c) (88:90) [14:48:18:408]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (88:90) [14:48:18:424]: End dialog not enabled MSI (c) (88:90) [14:48:18:424]: Original package ==> C:\PostgreSQL \8.3.7\temp\postgresql-8.3-int.msi MSI (c) (88:90) [14:48:18:424]: Package we're running from ==> C: \DOCUME~1\rjoseph\LOCALS~1\Temp\c2d01.msi MSI (c) (88:90) [14:48:18:424]: APPCOMPAT: looking for appcompat database entry with ProductCode '{B823632F-3B72-4514-8861- B961CE263224}'. MSI (c) (88:90) [14:48:18:424]: APPCOMPAT: no matching ProductCode found in database. MSI (c) (88:90) [14:48:18:424]: MSCOREE not loaded loading copy from system32 MSI (c) (88:90) [14:48:18:424]: Machine policy value 'TransformsSecure' is 0 MSI (c) (88:90) [14:48:18:424]: User policy value 'TransformsAtSource' is 0 MSI (c) (88:90) [14:48:18:424]: Machine policy value 'DisablePatch' is 0 MSI (c) (88:90) [14:48:18:424]: Machine policy value 'AllowLockdownPatch' is 0 MSI (c) (88:90) [14:48:18:424]: Machine policy value 'DisableLUAPatching' is 0 MSI (c) (88:90) [14:48:18:424]: Machine policy value 'DisableFlyWeightPatching' is 0 MSI (c) (88:90) [14:48:18:440]: APPCOMPAT: looking for appcompat database entry with ProductCode '{B823632F-3B72-4514-8861- B961CE263224}'. MSI (c) (88:90) [14:48:18:440]: APPCOMPAT: no matching ProductCode found in database. MSI (c) (88:90) [14:48:18:440]: Transforms are not secure. MSI (c) (88:90) [14:48:18:440]: Command Line: INTERNALLAUNCH=1 INSTALLLANG=en CURRENTDIRECTORY=C:\WINDOWS\system32 CLIENTUILEVEL=0 CLIENTPROCESSID=2952 MSI (c) (88:90) [14:48:18:440]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{FAD54106-3052-4D5E-9185-E64713E9368E}'. MSI (c) (88:90) [14:48:18:440]: Product Code passed to Engine.Initialize: '' MSI (c) (88:90) [14:48:18:440]: Product Code from property table before transforms: '{B823632F-3B72-4514-8861-B961CE263224}' MSI (c) (88:90) [14:48:18:440]: Product Code from property table after transforms: '{B823632F-3B72-4514-8861-B961CE263224}' MSI (c) (88:90) [14:48:18:440]: Product not registered: beginning first-time install . . . In this portion of the log, there is a mention of an error but I can't tell what the conclusion was: Action start 14:48:18: GetAvailableLocales. MSI (c) (88:38) [14:48:18:487]: Invoking remote custom action. DLL: C: \DOCUME~1\rjoseph\LOCALS~1\Temp\MSI5.tmp, Entrypoint: _GetAvailableLocales@4 MSI (c) (88:28) [14:48:18:487]: Cloaking enabled. MSI (c) (88:28) [14:48:18:487]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (88:28) [14:48:18:487]: Connected to service for CA interface. MSI (c) (88!60) [14:48:19:019]: PROPERTY CHANGE: Modifying LOCALE property. Its current value is 'DEFAULT'. Its new value: 'C'. MSI (c) (88!60) [14:48:19:019]: PROPERTY CHANGE: Modifying ENCODING property. Its current value is 'DEFAULT'. Its new value: 'SQL_ASCII'. MSI (c) (88!60) [14:48:19:019]: PROPERTY CHANGE: Modifying CLENCODE property. Its current value is 'DEFAULT'. Its new value: 'SQL_ASCII'. MSI (c) (88!60) [14:48:19:035]: Note: 1: 2259 2: 3: 4: MSI (c) (88!60) [14:48:19:051]: Note: 1: 2259 2: 3: 4: MSI (c) (88!60) [14:48:19:098]: Note: 1: 2259 2: 3: 4: MSI (c) (88!60) [14:48:19:098]: PROPERTY CHANGE: Modifying LOCALE property. Its current value is 'C'. Its new value: 'English_United States'. MSI (c) (88!60) [14:48:19:098]: PROPERTY CHANGE: Modifying ENCODING property. Its current value is 'SQL_ASCII'. Its new value: 'UTF8'. MSI (c) (88!60) [14:48:19:098]: PROPERTY CHANGE: Modifying ENCODING property. Its current value is 'UTF8'. Its new value: 'WIN1252'. MSI (c) (88!60) [14:48:19:098]: PROPERTY CHANGE: Modifying CLENCODE property. Its current value is 'SQL_ASCII'. Its new value: 'WIN1252'. MSI (c) (88:38) [14:48:19:098]: Leaked MSIHANDLE (3) of type 790540 for thread 2400 MSI (c) (88:38) [14:48:19:098]: Note: 1: 2769 2: GetAvailableLocales 3: 1 MSI (c) (88:38) [14:48:19:098]: Note: 1: 2205 2: 3: Error MSI (c) (88:38) [14:48:19:098]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2769 DEBUG: Error 2769: Custom Action GetAvailableLocales did not close 1 MSIHANDLEs. The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2769. The arguments are: GetAvailableLocales, 1, Action ended 14:48:19: GetAvailableLocales. Return value 1. MSI (c) (88:90) [14:48:19:098]: Doing action: LaunchConditions Action 14:48:19: LaunchConditions. Evaluating launch conditions Action start 14:48:19: LaunchConditions. Action ended 14:48:19: LaunchConditions. Return value 1. MSI (c) (88:90) [14:48:19:098]: Doing action: CheckAvailableDLLs Action 14:48:19: CheckAvailableDLLs. Action start 14:48:19: CheckAvailableDLLs. MSI (c) (88:D0) [14:48:19:113]: Invoking remote custom action. DLL: C: \DOCUME~1\rjoseph\LOCALS~1\Temp\MSI6.tmp, Entrypoint: _CheckAvailableDLLs@4 MSI (c) (88!B4) [14:48:19:693]: PROPERTY CHANGE: Modifying HAS_PYTHON property. Its current value is '0'. Its new value: '1'. MSI (c) (88!B4) [14:48:19:693]: PROPERTY CHANGE: Modifying SERVICEDOMAIN property. Its current value is '.'. Its new value: 'HOUC55304'. Action ended 14:48:19: CheckAvailableDLLs. Return value 1. MSI (c) (88:90) [14:48:19:693]: Skipping action: DisableInitdb (condition is false) . . . The next section with an error entry is: Action start 14:48:18: GetAvailableLocales. MSI (c) (88:38) [14:48:18:487]: Invoking remote custom action. DLL: C: \DOCUME~1\rjoseph\LOCALS~1\Temp\MSI5.tmp, Entrypoint: _GetAvailableLocales@4 MSI (c) (88:28) [14:48:18:487]: Cloaking enabled. MSI (c) (88:28) [14:48:18:487]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (88:28) [14:48:18:487]: Connected to service for CA interface. MSI (c) (88!60) [14:48:19:019]: PROPERTY CHANGE: Modifying LOCALE property. Its current value is 'DEFAULT'. Its new value: 'C'. MSI (c) (88!60) [14:48:19:019]: PROPERTY CHANGE: Modifying ENCODING property. Its current value is 'DEFAULT'. Its new value: 'SQL_ASCII'. MSI (c) (88!60) [14:48:19:019]: PROPERTY CHANGE: Modifying CLENCODE property. Its current value is 'DEFAULT'. Its new value: 'SQL_ASCII'. MSI (c) (88!60) [14:48:19:035]: Note: 1: 2259 2: 3: 4: MSI (c) (88!60) [14:48:19:051]: Note: 1: 2259 2: 3: 4: MSI (c) (88!60) [14:48:19:098]: Note: 1: 2259 2: 3: 4: MSI (c) (88!60) [14:48:19:098]: PROPERTY CHANGE: Modifying LOCALE property. Its current value is 'C'. Its new value: 'English_United States'. MSI (c) (88!60) [14:48:19:098]: PROPERTY CHANGE: Modifying ENCODING property. Its current value is 'SQL_ASCII'. Its new value: 'UTF8'. MSI (c) (88!60) [14:48:19:098]: PROPERTY CHANGE: Modifying ENCODING property. Its current value is 'UTF8'. Its new value: 'WIN1252'. MSI (c) (88!60) [14:48:19:098]: PROPERTY CHANGE: Modifying CLENCODE property. Its current value is 'SQL_ASCII'. Its new value: 'WIN1252'. MSI (c) (88:38) [14:48:19:098]: Leaked MSIHANDLE (3) of type 790540 for thread 2400 MSI (c) (88:38) [14:48:19:098]: Note: 1: 2769 2: GetAvailableLocales 3: 1 MSI (c) (88:38) [14:48:19:098]: Note: 1: 2205 2: 3: Error MSI (c) (88:38) [14:48:19:098]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2769 DEBUG: Error 2769: Custom Action GetAvailableLocales did not close 1 MSIHANDLEs. The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2769. The arguments are: GetAvailableLocales, 1, Action ended 14:48:19: GetAvailableLocales. Return value 1. MSI (c) (88:90) [14:48:19:098]: Doing action: LaunchConditions Action 14:48:19: LaunchConditions. Evaluating launch conditions Action start 14:48:19: LaunchConditions. Action ended 14:48:19: LaunchConditions. Return value 1. MSI (c) (88:90) [14:48:19:098]: Doing action: CheckAvailableDLLs Action 14:48:19: CheckAvailableDLLs. Action start 14:48:19: CheckAvailableDLLs. MSI (c) (88:D0) [14:48:19:113]: Invoking remote custom action. DLL: C: \DOCUME~1\rjoseph\LOCALS~1\Temp\MSI6.tmp, Entrypoint: _CheckAvailableDLLs@4 MSI (c) (88!B4) [14:48:19:693]: PROPERTY CHANGE: Modifying HAS_PYTHON property. Its current value is '0'. Its new value: '1'. MSI (c) (88!B4) [14:48:19:693]: PROPERTY CHANGE: Modifying SERVICEDOMAIN property. Its current value is '.'. Its new value: 'HOUC55304'. Action ended 14:48:19: CheckAvailableDLLs. Return value 1. MSI (c) (88:90) [14:48:19:693]: Skipping action: DisableInitdb (condition is false) . . . This last section is where the error message popped up: Action 14:53:27: InstallServices. Installing new services MSI (s) (18:BC) [14:53:27:448]: Executing op: ProgressTotal (Total=1,Type=1,ByteEquivalent=1300000) MSI (s) (18:BC) [14:53:27:448]: Executing op: ServiceInstall (Name=pgsql-8.3,DisplayName=PostgreSQL Database Server 8.3,ImagePath="C:\Program Files\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N "pgsql-8.3" -D "C:\Program Files\PostgreSQL\8.3\data \",ServiceType=16,StartType=2,ErrorControl=32769,,,,StartName=. \postgres,Password=**********,Description=PostgreSQL Database Server (postmaster)) MSI (s) (18:BC) [14:53:30:886]: Executing op: ActionStart (Name=StartServices,Description=Starting services,Template=Service: [1]) Action 14:53:30: StartServices. Starting services MSI (s) (18:BC) [14:53:30:886]: Executing op: ProgressTotal (Total=2,Type=1,ByteEquivalent=1300000) MSI (s) (18:BC) [14:53:30:886]: Executing op: ServiceControl (,Name=pgsql-8.3,Action=1,Wait=1,) StartServices: Service: PostgreSQL Database Server 8.3 MSI (s) (18:BC) [14:54:15:149]: Note: 1: 2205 2: 3: Error MSI (s) (18:BC) [14:54:15:149]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1920 MSI (c) (88:E4) [14:54:15:149]: Note: 1: 2205 2: 3: Error MSI (c) (88:E4) [14:54:15:149]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2835 DEBUG: Error 2835: The control ErrorIcon was not found on dialog ErrorDlg The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2835. The arguments are: ErrorIcon, ErrorDlg, Error 1920. Service 'PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start. Verify that you have sufficient privileges to start system services. Action 15:01:27: Cancel. Dialog created MSI (s) (18:BC) [15:01:19:562]: Note: 1: 2205 2: 3: Error MSI (s) (18:BC) [15:01:19:562]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709 MSI (s) (18:BC) [15:01:19:562]: Product: PostgreSQL 8.3 -- Error 1920. Service 'PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start. Verify that you have sufficient privileges to start system services. I hope this log is helpful in understanding something about the installation. Do you have any suggestions? Thanks, Ray
Raymond, I used the pgInstaller on the Win2K box and it is working. I downloaded from a different mirror. The installation ran a little different. Additionally, there seemed to be an issue with rights. The installer setup a user which I accepted but it came back saying that the rights weren't right (I don't remember the specifics). So I built a user and made it an administrator (the FAQ said it shouldn't be an administrator), but the installer responded with a statement of the effect that this user didn't have the correct rights. So I changed the user to a superuser. The installer liked that. But when the installation progressed to choosing languages, Python was no longer shown as available. I accepted the only one available and proceded. . . Not it works. The problem is I need Python functionality for Trac. Can I add it? How do I get where I need to be? Thanks, Ray
log_statement = none/ddl/mode/all
log_min_duration = <value> -->> to log query consumes more than set value
--
Thanks & Regards
Dhaval Jaiswal
From: Raymond O'Donnell <rod@iol.ie>
To: ray <Ray.Joseph@CDICorp.com>
Cc: pgsql-general@postgresql.org
Sent: Friday, March 20, 2009 12:34:17 AM
Subject: Re: [GENERAL] Installation Error, Server Won't Start
On 18/03/2009 22:22, ray wrote:
> I do not see an opportunity to request a log to be written. From the
> Psotgre site, I downloaded:
> postgresql-8.3.7-1-windows.exe
Ah, I see - that's the one-click installer, which is maintained by
EnterpriseDB. I haven't used that one; I was thinking of the community
installer (pgInstaller), and that's the one has the logging option.
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral..org/recitals
------------------------------------------------------------------
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general