Re: [GENERAL] Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results
On Tue, Jan 27, 2009 at 1:16 PM, Magnus Hagander wrote: > For example, consider what happens when your files are on a roaming > profile. And yes, profiles can more or less randomly move between being > roaming and local-copy in my experience... And you really don't want > that for your database files. It can also be more awkward from a management POV - it ties the cluster more tightly to that service user account (with no gain in security), and makes it more awkward for admins to get at the config files & certificates etc. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results
Holger Hoffstaette wrote: > On Tue, 27 Jan 2009 13:17:30 +0100, Magnus Hagander wrote: > >> Holger Hoffstaette wrote: >>> On Tue, 27 Jan 2009 16:10:26 +0900, ITAGAKI Takahiro wrote: >>> I'm not sure which directory should we create $PGDATA -- "My Documents", "Application Data", "Local Settings" or direct child of %USERPROFILE%, but anyway some of them would be better than "Program Files". >>> %USERNAME%/%APPDATA% >>> >>> These variables exist for good reasons.. >> Yes. For user apps. They pretty much suck for services. > > Wah? Please explain. I was under the impression that a service running > under some account has access to its profile and all the assorted things > that come with it. Is this not the case? It does - in theory. It doesn't always work. For example, consider what happens when your files are on a roaming profile. And yes, profiles can more or less randomly move between being roaming and local-copy in my experience... And you really don't want that for your database files. //Magnus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results
On Tue, 27 Jan 2009 13:17:30 +0100, Magnus Hagander wrote: > Holger Hoffstaette wrote: >> On Tue, 27 Jan 2009 16:10:26 +0900, ITAGAKI Takahiro wrote: >> >>> I'm not sure which directory should we create $PGDATA -- "My Documents", >>> "Application Data", "Local Settings" or direct child of %USERPROFILE%, but >>> anyway some of them would be better than "Program Files". >> >> %USERNAME%/%APPDATA% >> >> These variables exist for good reasons.. > > Yes. For user apps. They pretty much suck for services. Wah? Please explain. I was under the impression that a service running under some account has access to its profile and all the assorted things that come with it. Is this not the case? thanks Holger -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results
Harald Armin Massa wrote: > THE MORE hurting problem on Windows7 is the inability to start the > postgresql service. There must have been some changes to the service > framework / security > "security" which prevend the startup... Dave Page just posted a patch for that, so we'll hopefully have it fixed RSN. //Magnus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results
On Tue, Jan 27, 2009 at 12:18 PM, Harald Armin Massa wrote: > THE MORE hurting problem on Windows7 is the inability to start the > postgresql service. There must have been some changes to the service > framework / security > "security" which prevend the startup... I posted a patch for that to -hackers a couple of hours ago. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results
Holger, >>> 4.) it seems to be no longer "cool" to have your data below Program >>> Files / Program Files (x86) > That was never cool or good practice. Yes, we discussed that on pg-installer some time ago. But we were in good bad company, as Microsoft SQL Server and Exchange did similiar things. Quod licet iovi >> I'm not sure which directory should we create $PGDATA -- "My Documents", >> "Application Data", "Local Settings" or direct child of %USERPROFILE%, but >> anyway some of them would be better than "Program Files". > > %USERNAME%/%APPDATA% The default for "bigger data" seems to be \progdata on Windows 7. That is from observation only, as i.e. Ubisoft installs there. Not clear which %XX% that is... Nontheless: I usually pick my own data directory, as there have to be special provisions made concerning backup and viralscanners. THE MORE hurting problem on Windows7 is the inability to start the postgresql service. There must have been some changes to the service framework / security "security" which prevend the startup... 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! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results
Holger Hoffstaette wrote: > On Tue, 27 Jan 2009 16:10:26 +0900, ITAGAKI Takahiro wrote: > >> I'm not sure which directory should we create $PGDATA -- "My Documents", >> "Application Data", "Local Settings" or direct child of %USERPROFILE%, but >> anyway some of them would be better than "Program Files". > > %USERNAME%/%APPDATA% > > These variables exist for good reasons.. Yes. For user apps. They pretty much suck for services. //Magnus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results
On Tue, 27 Jan 2009 16:10:26 +0900, ITAGAKI Takahiro wrote: > Harald Armin Massa wrote: > >> 4.) it seems to be no longer "cool" to have your data below Program >> Files / Program Files (x86) That was never cool or good practice. > I'm not sure which directory should we create $PGDATA -- "My Documents", > "Application Data", "Local Settings" or direct child of %USERPROFILE%, but > anyway some of them would be better than "Program Files". %USERNAME%/%APPDATA% These variables exist for good reasons.. regards Holger -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results
Harald Armin Massa wrote: > 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\ I think all of those directories are only for executable files and not good to store any data. Is it safe to create database cluster under "C:\Documents and Settings\postgres" or "C:\Users\postgres" ? UAC often bytes us when we just try to modify the configuration file. I'm not sure which directory should we create $PGDATA -- "My Documents", "Application Data", "Local Settings" or direct child of %USERPROFILE%, but anyway some of them would be better than "Program Files". Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results
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=130) 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=130) 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,Cleanup