Re: Installing version 8.4 - Mailing list pgsql-general
From | Bob Pawley |
---|---|
Subject | Re: Installing version 8.4 |
Date | |
Msg-id | A3DBF81158174B579B5CC3564BA9D509@BobPC Whole thread Raw |
In response to | Re: Installing version 8.4 (Ashesh Vashi <ashesh.vashi@enterprisedb.com>) |
List | pgsql-general |
Hi Ashesh
Attached is the initcluster file.
At the end of the file -
"
' Secure the data directory
If IsVistaOrNewer() = True Then
WScript.Echo "Granting service account access to the data directory (using icacls):"
iRet = DoCmd("icacls """ & strDataDir & """ /T /C /grant:r """ & strOSUsername & """:M")
Else
WScript.Echo "Granting service account access to the data directory (using cacls):"
iRet = DoCmd("echo y|cacls """ & strDataDir & """ /E /T /C /G """ & strOSUsername & """:F")
End If
if iRet <> 0 Then
Warn "Failed to grant service account access to the data directory (" & strDataDir & ")"
End If
If IsVistaOrNewer() = True Then
WScript.Echo "Granting service account access to the data directory (using icacls):"
iRet = DoCmd("icacls """ & strDataDir & """ /T /C /grant:r """ & strOSUsername & """:M")
Else
WScript.Echo "Granting service account access to the data directory (using cacls):"
iRet = DoCmd("echo y|cacls """ & strDataDir & """ /E /T /C /G """ & strOSUsername & """:F")
End If
if iRet <> 0 Then
Warn "Failed to grant service account access to the data directory (" & strDataDir & ")"
End If
WScript.Echo "initcluster.vbs ran to completion"
WScript.Quit iWarn "
WScript.Quit iWarn "
Bob
From: Ashesh Vashi
Sent: Sunday, May 30, 2010 10:16 AM
To: Bob Pawley
Subject: Re: [GENERAL] Installing version 8.4
On Sun, May 30, 2010 at 8:41 PM, Bob Pawley <rjpawley@shaw.ca> wrote:
Hi AsheshWhere would I find initcluster.vbs ?
Installer calls initcluster.vbs after creating user.
I want to know the output of that script in the log file.
--
Ashesh Vashi
EnterpriseDB INDIA: www.enterprisedb.com
BobFrom: Ashesh VashiSent: Sunday, May 30, 2010 7:27 AMTo: Bob PawleySubject: Re: [GENERAL] Installing version 8.4Hi Bob,On Sun, May 30, 2010 at 4:30 PM, Bob Pawley <rjpawley@shaw.ca> wrote:Thanks for the vote of confidence Adrian.
However, being 2 months shy of 68, there may be enough time left for me to continue learning PostgreSQL/PostGIS and Delphi to accomplish what I want to accomplish.
I don't feel I should divert time to researching the intricacies of PostgreSQL installation. That's why I am asking the experts for help.
If anyone has some thoughts or suggestions the log is REALLY below in this e-mail.
The first 90% of the log is the installation prep and unpacking the different elements showing no problems until - (the first problem appears to be -- "Starting the database server...
Executing cscript //NoLogo "C:\Program Files\PostgresPlus\8.4SS\installer\server\startserver.vbs" postgresql-8.4
Script exit code: 1"
- but I have no idea what this actually means.)
Script output:
User account 'DESKTOP\postgres' already exists.
User 'DESKTOP\postgres' already member of 'Users' group.
C:\PROGRA~1\POSTGR~2\8.4SS\INSTAL~1\server\CREATE~1.EXE ran to completion
Script stderr:
Configuring database server startup...
Executing cscript //NoLogo "C:\Program Files\PostgresPlus\8.4SS\installer\server\startupcfg.vbs" 8.4 "postgres" "****" "C:\Program Files\PostgresPlus\8.4SS" "C:\Program Files\PostgresPlus\8.4SS\data" "postgresql-8.4"
Script exit code: 0
Script output:
Start DoCmd("C:\Program Files\PostgresPlus\8.4SS\bin\pg_ctl.exe" register -N postgresql-8.4 -U postgres -P "postgres" -D "C:\Program Files\PostgresPlus\8.4SS\data" -w)...
startupcfg.vbs ran to completion
Script stderr:
Creating menu shortcuts...
Executing cscript //NoLogo "C:\Program Files\PostgresPlus\8.4SS\installer\server\createshortcuts.vbs" 8.4 "postgres" 5432 "Postgres Plus Standard Server 8.4" "C:\Program Files\PostgresPlus\8.4SS" "C:\Program Files\PostgresPlus\8.4SS\data" "postgresql-8.4"
Script exit code: 0
Script output:
Start FixupFile(C:\Program Files\PostgresPlus\8.4SS\scripts\serverctl.vbs)...
Opening file for reading...
Closing file (reading)...
Replacing placeholders...
Opening file for writing...
Closing file...
End FixupFile()...
Start FixupFile(C:\Program Files\PostgresPlus\8.4SS\scripts\runpsql.bat)...
Opening file for reading...
Closing file (reading)...
Replacing placeholders...
Opening file for writing...
Closing file...
End FixupFile()...
createshortcuts.vbs ran to completion
Script stderr:
Starting the database server...
Executing cscript //NoLogo "C:\Program Files\PostgresPlus\8.4SS\installer\server\startserver.vbs" postgresql-8.4
Script exit code: 1
Script output:
Starting postgresql-8.4
Failed to start the database server (15)This suggests that - it failed to start the postgresql server.But, I would love you see -what is the output after of initcluster.vbs script.You won't find output of initcluster.vbs, if you're using existing data directory.
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\Program Files\PostgresPlus\8.4SS\installer\server\startserver.vbs" postgresql-8.4 : Program ended with an error exit code
Problem running post-install step. Installation may not complete correctly
Failed to start the database server.
Problem running post-install step. Installation may not complete correctly
Failed to start the database server.
Creating Uninstaller
Creating uninstaller 25%
Creating uninstaller 50%
Creating uninstaller 75%
Creating uninstaller 100%
Installation completed
Log finished 05/29/10 at 15:37:22To: "Bob Pawley" <rjpawley@shaw.ca>
--------------------------------------------------
From: "Adrian Klaver" <adrian.klaver@gmail.com>
Sent: Saturday, May 29, 2010 4:35 PM
Cc: <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] Installing version 8.4On Saturday 29 May 2010 4:26:08 pm Bob Pawley wrote:Found it in XP it doesn't seem to exist in Windows 7. I can't even find Doc
and Settings in 7.
It's a large file. I'm not sure what is needed but here is the latter part
of the file.
Bob
Actually I was thinking you might want to browse the file to see if anything
stands out. Most of the issues I have seen on this list relative to Windows
installs relate to permissions, so that would be a good place to start.
--
Adrian Klaver
adrian.klaver@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Attachment
pgsql-general by date: