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  
 
WScript.Echo "initcluster.vbs ran to completion"
WScript.Quit iWarn  "
 
Bob
 

Sent: Sunday, May 30, 2010 10:16 AM
Subject: Re: [GENERAL] Installing version 8.4

Hi Bob,


On Sun, May 30, 2010 at 8:41 PM, Bob Pawley <rjpawley@shaw.ca> wrote:
Hi Ashesh
 
Where 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 
 
Bob
 
 

Sent: Sunday, May 30, 2010 7:27 AM
Subject: Re: [GENERAL] Installing version 8.4

Hi 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.

--
Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise Postgres Company


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:22


--------------------------------------------------
From: "Adrian Klaver" <adrian.klaver@gmail.com>
Sent: Saturday, May 29, 2010 4:35 PM
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: <pgsql-general@postgresql.org>

Subject: Re: [GENERAL] Installing version 8.4

On 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:

Previous
From: Peter Geoghegan
Date:
Subject: Re: server-side extension in c++
Next
From: Peter Geoghegan
Date:
Subject: Re: server-side extension in c++