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

From: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>
To: "Gopavarapu, Rambabu (HP Software)" <rambabu(dot)g(at)hp(dot)com>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: user 'postgres' can't we make it as Domain User while installing PostgreSQL9.0
Date: 2013-10-24 10:13:29
Message-ID: CANFyU94qdmVz33Oc8uney0caqwXZvBD=h8he5Cv5OUN0qDdasw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Gopavarapu, Rambabu (HP Software) 2013-10-24 13:39:50 Re: user 'postgres' can't we make it as Domain User while installing PostgreSQL9.0
Previous Message Neel Patel 2013-10-24 05:13:11 Re: [pgadmin-support] pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3