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

Hi Sandeep/Team,

Yea, We tried installing Postegres alone but it is failed with domain user account.

To get clarity on how to drive this case, Please confirm whether it is supported scenario or not?

Regards,
Ram

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

If the domain user that is running the installer has proper permissions, then PostgreSQL installation should be successful as well. Did you try just running the PostgreSQL installer?

On Wed, Oct 23, 2013 at 2:08 PM, Gopavarapu, Rambabu (HP Software) <rambabu(dot)g(at)hp(dot)com<mailto:rambabu(dot)g(at)hp(dot)com>> wrote:
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<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

--
Sandeep Thakkar
Senior Software Engineer
[http://www.enterprisedb.com/sites/default/files/EDB-logo-4c.png]

Phone: +91.20.30589505

Website: www.enterprisedb.com<http://www.enterprisedb.com>
EnterpriseDB Blog: http://blogs.enterprisedb.com/
Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.