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

If you're using a domain account, you need to create it first, and ensure
it has the "log on as a service" right. Then, make sure you pass the domain
and account name to the installer (e.g. DOMAIN\postgres) so it knows to use
it for the service account. For example (from memory):

./postgresql-9.3.1-windows.exe --serviceaccount DOMAIN\postgres

On Thu, Oct 24, 2013 at 2:39 PM, Gopavarapu, Rambabu (HP Software) <
rambabu(dot)g(at)hp(dot)com> wrote:

> 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> 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]
> *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> 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]
> *Sent:* Monday, October 14, 2013 4:24 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****
>
> ****
>
> 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> 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****
>
>
>
> Phone: +91.20.30589505
>
> Website: 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.****
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company