Re: user 'postgres' can't we make it as Domain User while installing PostgreSQL9.0

Hi Sandeep,

Do you have any solution findings for my concern.

Need the team's valuable suggestions for us to move ahead.

Regards,
Ram

From: Gopavarapu, Rambabu (HP Software)
Sent: Tuesday, October 15, 2013 1:03 PM
To: 'Sandeep Thakkar'
Subject: RE: [pgadmin-support] user 'postgres' can't we make it as Domain User while installing PostgreSQL9.0

Hi Sandeep,

1. The log which I have sent is ,to give you the context and how we are installing the postgres which bundled in our product.

2. I do not have a log file where installation is failed with Domain user account (log file not found).

3. However the error message which I mentioned in previous mail is thrown on UI while installing postgres bundled with our product.

I just captured the following messages from install-postgres log,

1. Why does postgres installation fails while installing as Domain user, If so, what is the work around or solution to install the postgresSQL9.0 using Domain User accounts?

2. Is the below command 'createuser.exe' can support to create 'postgres' user as domain user account?, please suggest.

Preparing to Install
Executing C:\Users\Administrator\AppData\Local\Temp\1\postgresql_installer\createuser.exe "." "postgres" "****"
Script exit code: 0

Script output:
Successfully Hide the user 'postgres' on the logon screen.
Granted the 'Log on as a service' right to 'SHRLR08\postgres'
User account 'SHRLR08\postgres' added to 'Users' group.
C:\Users\ADMINI~1\AppData\Local\Temp\1\POSTGR~1\CREATE~1.EXE ran to completion

Script stderr:

Executing C:\Users\Administrator\AppData\Local\Temp\1\postgresql_installer\validateuser.exe "." "postgres" "****"
Script exit code: 0

Script output:
C:\Users\ADMINI~1\AppData\Local\Temp\1\POSTGR~1\VALIDA~1.EXE ran to completion

Regards,
Ram
From: Sandeep Thakkar [mailto:sandeep(dot)thakkar(at)enterprisedb(dot)com]
Sent: Monday, October 14, 2013 4:52 PM
To: Gopavarapu, Rambabu (HP Software)
Subject: Re: [pgadmin-support] user 'postgres' can't we make it as Domain User while installing PostgreSQL9.0

The installation log does not show any failure. Infact, the initcluster script was successfully executed it seems.. Moreover, the error message that you displayed does not look like coming from the PostgreSQL installation. Can you please confirm?

On Mon, Oct 14, 2013 at 4:42 PM, Gopavarapu, Rambabu (HP Software) <rambabu(dot)g(at)hp(dot)com<mailto:rambabu(dot)g(at)hp(dot)com>> wrote:
Sandeep, thanks for your quick attention:

postgres installation fails with permission errors.

The installation of postgres will fail with error "Failed to initialise the database cluster with initdb +domain admin ",

This is due to a known postgre issue .

more details available here http://forums.enterprisedb.com/posts/list/2044.page#7503<http://forums.enterprisedb.com/posts/list/2044.page>

Attached the install-postgres.txt file for your information.( This log file is captured on a successful installation machine, I do see such file for a failure one).

Regards,
Ram

From: Sandeep Thakkar [mailto:sandeep(dot)thakkar(at)enterprisedb(dot)com<mailto:sandeep(dot)thakkar(at)enterprisedb(dot)com>]
Sent: Monday, October 14, 2013 4:24 PM
To: Gopavarapu, Rambabu (HP Software)
Cc: pgadmin-support(at)postgresql(dot)org<mailto:pgadmin-support(at)postgresql(dot)org>
Subject: Re: [pgadmin-support] user 'postgres' can't we make it as Domain User while installing PostgreSQL9.0

I think, PostgreSQL should have installed fine in silent/unattended mode. What options are you providing with the installer? What does the install-postgresql.log in the system temp says?

On Mon, Oct 14, 2013 at 3:41 PM, Gopavarapu, Rambabu (HP Software) <rambabu(dot)g(at)hp(dot)com<mailto:rambabu(dot)g(at)hp(dot)com>> wrote:
Dear Experts,

The default user 'postgres' that is shipped while installing PostgresSQL9.0, can't be created as domain user account ?

We have a following requirement:

We have our own product XYZ, and we wanted bundle it PostgresSQL9.0 as a sailent installer during our product install. Our product can be installed using Domain User accounts, where as Postgres installation is failing (with Domain User account).

Please suggest a solution.

Regards,
Ram

--
Sandeep Thakkar

--
Sandeep Thakkar