Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results - Mailing list pgsql-general

Hello,

my first results of installation-attempts of PostgreSQL 8.3.5 from
pginstaller on Windows 7 64bit:

1.) after getting up to "initialize database cluster", Dialog appears:
"Secondary Logon" Service not running. Please start this service and retry

Maybe some "net start seclogon" would be helpfull if W7 is detected by
installer?


2) installation copies a lot of stuff, moves up to "services get
started", which takes A LOT OF TIME
as of logfile:
[....]
MSI (s) (F0:C4) [12:29:49:297]: Executing op:
ActionStart(Name=StartServices,Description=Dienste werden
gestartet,Template=Dienst: [1])
Aktion 12:29:49: StartServices. Dienste werden gestartet
MSI (s) (F0:C4) [12:29:49:298]: Executing op:
ProgressTotal(Total=1,Type=1,ByteEquivalent=1300000)
MSI (s) (F0:C4) [12:29:49:298]: Executing op:
ServiceControl(,Name=pgsql-8.3,Action=1,Wait=1,)
StartServices: Dienst: PostgreSQL Database Server 8.3

and finally fails with "... service could not be startet, please check
if you have enough rights to start system services"
[retry] / [cancel]
(btw, I am running the installer from an administrator prompt)

"retry" gives another time period to meditate & contemplate & wait; "Cancel"

leads to rollback of the installation:
MSI (s) (F0:C4) [12:29:49:297]: Executing op:
ActionStart(Name=StartServices,Description=Dienste werden
gestartet,Template=Dienst: [1])
Aktion 12:29:49: StartServices. Dienste werden gestartet
MSI (s) (F0:C4) [12:29:49:298]: Executing op:
ProgressTotal(Total=1,Type=1,ByteEquivalent=1300000)
MSI (s) (F0:C4) [12:29:49:298]: Executing op:
ServiceControl(,Name=pgsql-8.3,Action=1,Wait=1,)
StartServices: Dienst: PostgreSQL Database Server 8.3
MSI (s) (F0:C4) [12:33:25:956]: Note: 1: 2205 2:  3: Error
MSI (s) (F0:C4) [12:33:25:956]: Note: 1: 2228 2:  3: Error 4: SELECT
`Message` FROM `Error` WHERE `Error` = 1920
MSI (c) (DC:50) [12:33:25:958]: Note: 1: 2205 2:  3: Error
MSI (c) (DC:50) [12:33:25:958]: 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
Bei der Installation dieses Pakets ist ein unerwarteter Fehler
aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem
vor. Der Fehlercode ist 2835. Argumente: ErrorIcon, ErrorDlg,
Fehler 1920. Der Dienst PostgreSQL Database Server 8.3 (pgsql-8.3)
konnte nicht gestartet werden. Überprüfen Sie, ob Sie ausreichende
Berechtigungen zum Starten von Systemdiensten besitzen.
MSI (s) (F0:18) [12:34:43:812]: I/O on thread 3064 could not be
cancelled. Error: 1168
MSI (s) (F0:18) [12:34:43:812]: I/O on thread 2040 could not be
cancelled. Error: 1168
MSI (s) (F0:18) [12:34:43:812]: I/O on thread 3636 could not be
cancelled. Error: 1168
MSI (s) (F0:18) [12:34:43:812]: I/O on thread 3268 could not be
cancelled. Error: 1168
MSI (s) (F0:18) [12:34:43:812]: I/O on thread 3776 could not be
cancelled. Error: 1168
MSI (s) (F0:18) [12:34:43:812]: I/O on thread 2516 could not be
cancelled. Error: 1168
MSI (s) (F0:18) [12:34:43:812]: I/O on thread 3848 could not be
cancelled. Error: 1168
MSI (s) (F0:C4) [12:34:43:813]: Note: 1: 2205 2:  3: Error
MSI (s) (F0:C4) [12:34:43:813]: Note: 1: 2228 2:  3: Error 4: SELECT
`Message` FROM `Error` WHERE `Error` = 1709
MSI (s) (F0:C4) [12:34:43:813]: Produkt: PostgreSQL 8.3 -- Fehler
1920. Der Dienst PostgreSQL Database Server 8.3 (pgsql-8.3) konnte
nicht gestartet werden. Überprüfen Sie, ob Sie ausreichende
Berechtigungen zum Starten von Systemdiensten besitzen.

MSI (s) (F0:C4) [12:34:43:813]: Note: 1: 2205 2:  3: Error
MSI (s) (F0:C4) [12:34:43:813]: Note: 1: 2228 2:  3: Error 4: SELECT
`Message` FROM `Error` WHERE `Error` = 1602
MSI (c) (DC:50) [12:34:43:816]: Note: 1: 2205 2:  3: Error
MSI (c) (DC:50) [12:34:43:816]: 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
Bei der Installation dieses Pakets ist ein unerwarteter Fehler
aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem
vor. Der Fehlercode ist 2835. Argumente: ErrorIcon, ErrorDlg,
Sind Sie sicher, dass Sie den Vorgang abbrechen möchten?
Aktion beendet um 12:34:46: InstallFinalize. Rückgabewert 3.
MSI (s) (F0:C4) [12:34:46:169]: User policy value 'DisableRollback' is 0
MSI (s) (F0:C4) [12:34:46:169]: Machine policy value 'DisableRollback' is 0
MSI (s) (F0:C4) [12:34:46:172]: Executing op:

Header(Signature=1397708873,Version=500,Timestamp=976774067,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (F0:C4) [12:34:46:172]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (F0:C4) [12:34:46:173]: Executing op:
DialogInfo(Type=1,Argument=PostgreSQL 8.3)
MSI (s) (F0:C4) [12:34:46:173]: Executing op:
RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Aktion wird
rückgängig gemacht:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Sicherungsdateien
werden entfernt,CleanupTemplate=Datei: [1])
Aktion 12:34:46: Rollback. Aktion wird rückgängig gemacht:
Rollback: Dienste werden gestartet
MSI (s) (F0:C4) [12:34:46:175]: Executing op:
ActionStart(Name=StartServices,Description=Dienste werden
gestartet,Template=Dienst: [1])
MSI (s) (F0:C4) [12:34:46:175]: Executing op:
ProductInfo(ProductKey={B823632F-3B72-4514-8861-B961CE263224},ProductName=PostgreSQL

8.3,PackageName=postgresql-8.3-int.msi,Language=1033,Version=134414336,Assignment=1,ObsoleteArg=0,,,PackageCode={141FAE64-8F91-4C88-AF89-D1E6960734EC},,,InstanceType=0,LUASetting=0,RemoteURTInstalls=0,ProductDeploymentFlags=3)
MSI (c) (DC:50) [12:35:34:631]: Note: 1: 2205 2:  3: Error
MSI (c) (DC:50) [12:35:34:631]: Note: 1: 2228 2:  3: Error 4: SELECT
`Message` FROM `Error` WHERE `Error` = 2888
DEBUG: Error 2888:  Executing the TextStyle view failed
Bei der Installation dieses Pakets ist ein unerwarteter Fehler
aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem
vor. Der Fehlercode ist 2888. Argumente: TextStyle, ,
MSI (s) (F0:C4) [12:34:46:176]: Executing op:
ServiceControl(,Name=pgsql-8.3,Action=2,Wait=1,)
MSI (s) (F0:C4) [12:35:57:181]: Executing op:
ServiceControl(,Name=pgsql-8.3,Action=2,Wait=1,)
Rollback: Neue Dienste werden installiert
MSI (s) (F0:C4) [12:35:57:183]: Executing op:
ActionStart(Name=InstallServices,Description=Neue Dienste werden
installiert,Template=Dienst: [2])
MSI (s) (F0:C4) [12:35:57:183]: Executing op:
ServiceControl(,Name=pgsql-8.3,Action=8,,)
Rollback: Systemregistrierungwerte werden geschrieben

[.....]

with  not so really clear end:

MSI (c) (DC:F8) [12:36:04:160]: Produkt: PostgreSQL 8.3 --
Installation fehlgeschlagen.
(that is: installation failed)

MSI (c) (DC:F8) [12:36:04:161]: Windows Installer installed the
product. Product Name: PostgreSQL 8.3. Product Version: 8.3. Product
Language: 1031. Manufacturer: PostgreSQL Global Development Group.
Installation success or error status: 1603.

MSI (c) (DC:F8) [12:36:04:163]: Grabbed execution mutex.
MSI (c) (DC:F8) [12:36:04:163]: Cleaning up uninstalled install
packages, if any exist
MSI (c) (DC:F8) [12:36:04:165]: MainEngineThread is returning 1603
=== Verbose logging stopped: 24.01.2009  12:36:04 ===


On the bright side: a data directory containing the usual PostgreSQL
Structure is left behind.

3.) next try: installing PostgreSQL without creating database cluster
(which, as second try with that initdb-ed directory from first try is
the default)
(data directory contains of actual version, which will be used...)

now PostgreSQL installes all fine, even creates a service, and gives
me best wishes on successfull install
eventvwr/ applicatioN:

Protokollname: Application
Quelle:        MsiInstaller
Datum:         24.01.2009 12:42:40
Ereignis-ID:   1033
Aufgabenkategorie:Keine
Ebene:         Informationen
Schlüsselwörter:Klassisch
Benutzer:      TempleC7\ham
Computer:      TempleC7
Beschreibung:
Windows Installer installed the product. Product Name: PostgreSQL 8.3.
Product Version: 8.3. Product Language: 1031. Manufacturer: PostgreSQL
Global Development Group. Installation success or error status: 0.
Ereignis-XML:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MsiInstaller" />
    <EventID Qualifiers="0">1033</EventID>
    <Level>4</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2009-01-24T11:42:40.000000000Z" />
    <EventRecordID>2513</EventRecordID>
    <Channel>Application</Channel>
    <Computer>TempleC7</Computer>
    <Security UserID="S-1-5-21-1349645822-3266984892-1315167842-1000" />
  </System>
  <EventData>
    <Data>PostgreSQL 8.3</Data>
    <Data>8.3</Data>
    <Data>1031</Data>
    <Data>0</Data>
    <Data>PostgreSQL Global Development Group</Data>
    <Data>(NULL)</Data>
    <Data>
    </Data>

<Binary>7B42383233363332462D334237322D343531342D383836312D4239363143453236333232347D3030303036633862393261316635626664333663353862373533333535343138626262613030303030373034</Binary>
  </EventData>
</Event>
of course, service is not running...


4.) after 3.): net start pgsql-8.3
Windows tries really hard. gives me way more then 80 enddots on its
try of "PostreSQL [...] gets started ............
but finally fails, <Data>Timed out waiting for server startup</Data>
(which is also the record within application.log)

Security gives:
Anmeldeversuch mit expliziten Anmeldeinformationen. [logon attempt
with explicit logon information]

    Kontoname:        postgres
    Kontodomäne:        TempleC7

Ein Konto wurde erfolgreich angemeldet. [account logon successfull]
Neue Anmeldung:
    Sicherheits-ID:        TempleC7\postgres
    Kontoname:        postgres
    Kontodomäne:        TempleC7
    Anmelde-ID:        0x471c6a

Einer neuen Anmeldung wurden besondere Rechte zugewiesen. [special
rights where granted to a logon]
Antragsteller:
    Sicherheits-ID:        TempleC7\postgres
    Kontoname:        postgres
    Kontodomäne:        TempleC7
    Anmelde-ID:        0x471c6a
Berechtigungen:        SeImpersonatePrivilege

and after that:
Ein Konto wurde abgemeldet. [account was logged of]

Antragsteller:
    Sicherheits-ID:        TempleC7\postgres
    Kontoname:        postgres
    Kontodomäne:        TempleC7
    Anmelde-ID:        0x471c6a

Anmeldetyp:            5

-> service does not start.

5.) So, trying as my default user: a) adding postgresql\8.3\bin to my path
b)
pg_ctl start -D d:\ghum\data83
server starting

D:\ghum\data83>2009-01-24 12:55:27 CET LOG:  loaded library "$libdir/plugins/plu
gin_debugger.dll"

.. which gives me a FINE running postgresql 8.3


C:\Users\ham>psql -U postgres --port=5433
Password for user postgres:
Welcome to psql 8.3.5, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

Warning: Console code page (850) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.

postgres=#


4.) it seems to be no longer "cool" to have your data below Program
Files / Program Files (x86)
The default as of know is \ProgramData\<application>

5.) so: PostgreSQL somehow works on Windows 7 64bit; BUT not running as service

I would be willing to conduct more tests or try other things or
provide logs, please contact me! :)

Best wishes

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
EuroPython 2009 will take place in Birmingham - Stay tuned!