Thread: installer woes, 9.1 on windows 2008 R2
trying to install 9.1.9 64bit on a win2008 r2 server and getting a failure of the initdb phase, with no clue why.
I've installed the application on C:\postgresql\9.1\ and the data on D:\postgresql\9.1\data ... after the first try, I added the LOCAL\postgres user to the permissions on the D:\postgresql\9.1 directory and gave it full control, this propagated to the .\data dir too, then I tried running the installer again (since there's no clues how to manually invoke the initdb process properly). same error, no clues.
is there an installation log somewhere? I haven't found it in either \postgresql\ path.
if it matters, this server is a member of the corporate active directory, as is my user account that I ran the installer from (but said user account is a member o the local Administrators, and the PG installer invoked the privilege elevation thing when it started)
I've installed the application on C:\postgresql\9.1\ and the data on D:\postgresql\9.1\data ... after the first try, I added the LOCAL\postgres user to the permissions on the D:\postgresql\9.1 directory and gave it full control, this propagated to the .\data dir too, then I tried running the installer again (since there's no clues how to manually invoke the initdb process properly). same error, no clues.
'problem running post-install step. ....
The database cluster initialization failed'.
is there an installation log somewhere? I haven't found it in either \postgresql\ path.
if it matters, this server is a member of the corporate active directory, as is my user account that I ran the installer from (but said user account is a member o the local Administrators, and the PG installer invoked the privilege elevation thing when it started)
-- john r pierce 37N 122W somewhere on the middle of the left coast
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of John R Pierce Sent: Wednesday, June 26, 2013 3:38 PM To: PostgreSQL Subject: [GENERAL] installer woes, 9.1 on windows 2008 R2 trying to install 9.1.9 64bit on a win2008 r2 server and getting a failure of the initdb phase, with no clue why. I've installed the application on C:\postgresql\9.1\ and the data on D:\postgresql\9.1\data ... after the first try, Iadded the LOCAL\postgres user to the permissions on the D:\postgresql\9.1 directory and gave it full control, this propagatedto the .\data dir too, then I tried running the installer again (since there's no clues how to manually invokethe initdb process properly). same error, no clues. 'problem running post-install step. .... The database cluster initialization failed'. is there an installation log somewhere? I haven't found it in either \postgresql\ path. if it matters, this server is a member of the corporate active directory, as is my user account that I ran the installerfrom (but said user account is a member o the local Administrators, and the PG installer invoked the privilege elevationthing when it started) -- john r pierce 37N 122W somewhere on the middle of the left coast Look for bitrock_installer.log in the \Users\<account_you_are_using>\AppData\Local\Temp. Or just do search for bitrock_installer.log file. Igor Neyman
On 6/26/2013 12:49 PM, Igor Neyman wrote:
> Look for bitrock_installer.log in the \Users\<account_you_are_using>\AppData\Local\Temp.
> Or just do search for bitrock_installer.log file.
ahhh. two weirdnesses below...
A) why is it using 'myusername' (the account I ran the installer from)
instead of the postgres service account?
B) why can't it change the permissions?
..........
[11:35:51] Running the post-installation/upgrade actions:
[11:35:51] Delete the temporary scripts directory...
[11:35:51] Write the base directory to the ini file...
[11:35:51] Write the version number to the ini file...
Initialising the database cluster (this may take a few minutes)...
Executing cscript //NoLogo
"C:\PostgreSQL\9.1/installer/server/initcluster.vbs" "postgres"
"postgres" "****" "C:\PostgreSQL\9.1" "D:\PostgreSQL\9.1\data" 5432
"DEFAULT"
Script exit code: 1
Script output:
WScript.Shell Initialized...
Scripting.FileSystemObject initialized...
Called CreateDirectory(D:\PostgreSQL\9.1\data)...
Called CreateDirectory(D:\PostgreSQL\9.1)...
Called CreateDirectory(D:\PostgreSQL)...
Called CreateDirectory(D:\)...
WScript.Network initialized...
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:6.1
MajorVersion:6
Ensuring we can read the path D: (using icacls) to myusername:
Executing batch file 'rad72A5A.bat'...
processed file: D:\
Successfully processed 1 files; Failed processing 0 files
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:6.1
MajorVersion:6
Ensuring we can read the path D:\PostgreSQL (using icacls) to myusername:
Executing batch file 'rad72A5A.bat'...
processed file: D:\PostgreSQL
Successfully processed 1 files; Failed processing 0 files
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:6.1
MajorVersion:6
Ensuring we can read the path D:\PostgreSQL\9.1 (using icacls) to
myusername:
Executing batch file 'rad72A5A.bat'...
processed file: D:\PostgreSQL\9.1
Successfully processed 1 files; Failed processing 0 files
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:6.1
MajorVersion:6
Ensuring we can read the path D:\PostgreSQL\9.1\data (using icacls) to
myusername:
Executing batch file 'rad72A5A.bat'...
processed file: D:\PostgreSQL\9.1\data
Successfully processed 1 files; Failed processing 0 files
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:6.1
MajorVersion:6
Ensuring we can write to the data directory (using icacls) to myusername:
Executing batch file 'rad72A5A.bat'...
processed file: D:\PostgreSQL\9.1\data
Successfully processed 1 files; Failed processing 0 files
Executing batch file 'rad72A5A.bat'...
The files belonging to this database system will be owned by user
"myusername".
This user must also own the server process.
The database cluster will be initialized with locale English_United
States.1252.
The default text search configuration will be set to "english".
fixing permissions on existing directory D:/PostgreSQL/9.1/data ...
initdb: could not change permissions of directory
"D:/PostgreSQL/9.1/data": Permission denied
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
--
john r pierce 37N 122W
somewhere on the middle of the left coast
> -----Original Message----- > From: pgsql-general-owner@postgresql.org [mailto:pgsql-general- > owner@postgresql.org] On Behalf Of John R Pierce > Sent: Wednesday, June 26, 2013 4:13 PM > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] installer woes, 9.1 on windows 2008 R2 > > On 6/26/2013 12:49 PM, Igor Neyman wrote: > > Look for bitrock_installer.log in the > \Users\<account_you_are_using>\AppData\Local\Temp. > > Or just do search for bitrock_installer.log file. > > ahhh. two weirdnesses below... > > A) why is it using 'myusername' (the account I ran the installer from) instead > of the postgres service account? This is correct. User 'myusername' running Install should have permissions to the whole D:\PostgreSQL (with subdirectories). User Postgres needs permissions only to D:\PostgreSQL\9.1\data. So, according to this: > fixing permissions on existing directory D:/PostgreSQL/9.1/data ... > initdb: could not change permissions of directory > "D:/PostgreSQL/9.1/data": Permission denied 'myusername' couldn't grant permissions on this folder to "postgres" user. > B) why can't it change the permissions? Try to look at Windows Event Log, m.b. there will be some useful info. M.b. you need to run installer local (not corporate active directory) account, still member of local Administrators group. Also, from your original posting: " I added the LOCAL\postgres user to the permissions on the D:\postgresql\9.1 directory and gave it full control" You don't have to create Postgres account "manually" and grant him privileges - installer does it for you. Could this beyour problem? Regards, Igor Neyman > > .......... > [11:35:51] Running the post-installation/upgrade actions: > [11:35:51] Delete the temporary scripts directory... > [11:35:51] Write the base directory to the ini file... > [11:35:51] Write the version number to the ini file... > Initialising the database cluster (this may take a few minutes)... > Executing cscript //NoLogo > "C:\PostgreSQL\9.1/installer/server/initcluster.vbs" "postgres" > "postgres" "****" "C:\PostgreSQL\9.1" "D:\PostgreSQL\9.1\data" 5432 > "DEFAULT" > Script exit code: 1 > > Script output: > WScript.Shell Initialized... > Scripting.FileSystemObject initialized... > > Called CreateDirectory(D:\PostgreSQL\9.1\data)... > Called CreateDirectory(D:\PostgreSQL\9.1)... > Called CreateDirectory(D:\PostgreSQL)... > Called CreateDirectory(D:\)... > WScript.Network initialized... > Called IsVistaOrNewer()... > 'winmgmts' object initialized... > Version:6.1 > MajorVersion:6 > Ensuring we can read the path D: (using icacls) to myusername: > Executing batch file 'rad72A5A.bat'... > processed file: D:\ > Successfully processed 1 files; Failed processing 0 files > > Called IsVistaOrNewer()... > 'winmgmts' object initialized... > Version:6.1 > MajorVersion:6 > Ensuring we can read the path D:\PostgreSQL (using icacls) to myusername: > Executing batch file 'rad72A5A.bat'... > processed file: D:\PostgreSQL > Successfully processed 1 files; Failed processing 0 files > > Called IsVistaOrNewer()... > 'winmgmts' object initialized... > Version:6.1 > MajorVersion:6 > Ensuring we can read the path D:\PostgreSQL\9.1 (using icacls) to > myusername: > Executing batch file 'rad72A5A.bat'... > processed file: D:\PostgreSQL\9.1 > Successfully processed 1 files; Failed processing 0 files > > Called IsVistaOrNewer()... > 'winmgmts' object initialized... > Version:6.1 > MajorVersion:6 > Ensuring we can read the path D:\PostgreSQL\9.1\data (using icacls) to > myusername: > Executing batch file 'rad72A5A.bat'... > processed file: D:\PostgreSQL\9.1\data Successfully processed 1 files; > Failed processing 0 files > > Called IsVistaOrNewer()... > 'winmgmts' object initialized... > Version:6.1 > MajorVersion:6 > Ensuring we can write to the data directory (using icacls) to myusername: > Executing batch file 'rad72A5A.bat'... > processed file: D:\PostgreSQL\9.1\data Successfully processed 1 files; > Failed processing 0 files > > Executing batch file 'rad72A5A.bat'... > The files belonging to this database system will be owned by user > "myusername". > This user must also own the server process. > > The database cluster will be initialized with locale English_United States.1252. > The default text search configuration will be set to "english". > > fixing permissions on existing directory D:/PostgreSQL/9.1/data ... > initdb: could not change permissions of directory > "D:/PostgreSQL/9.1/data": Permission denied > > Called Die(Failed to initialise the database cluster with initdb)... > Failed to initialise the database cluster with initdb > > Script stderr: > Program ended with an error exit code > > -- > john r pierce 37N 122W > somewhere on the middle of the left coast >
On 6/27/2013 6:44 AM, Igor Neyman wrote: > Try to look at Windows Event Log, m.b. there will be some useful info. nada but unrelated noise > M.b. you need to run installer local (not corporate active directory) account, still member of local Administrators group. hmmm. having local accounts violates corporate security policies :-/ > Also, from your original posting: > " I added the LOCAL\postgres user to the permissions on the D:\postgresql\9.1 directory and gave it full control" > > You don't have to create Postgres account "manually" and grant him privileges - installer does it for you. Could thisbe your problem? it created the LOCAL_MACHINE\postgres account, but it failed at adding it to the ACL for D:\postgresql\9.1\data -- john r pierce 37N 122W somewhere on the middle of the left coast