Re: "1-Click" installer problems

See attached attached OneClick_PG_Installer notes.

Igor Neyman

> -----Original Message-----
> From: John Gage [mailto:jsmgage@numericable.fr]
> Sent: Friday, April 02, 2010 3:44 AM
> To: sachin.srivastava@enterprisedb.com
> Cc: pgsql-general@postgresql.org
> Subject: Re: "1-Click" installer problems
>
> There is a CLI option where?  Forgive my ignorance, please.
> Does it appear in the one-click installer?
>
> John
>
>
> On Apr 2, 2010, at 9:19 AM, Sachin Srivastava wrote:
>
>
>     There is a CLI option --serviceaccount <username> which
> a user can use to make any user the owner of postgres service
> and data files.
>
>     Also, if you choose 'postgres' as the service account
> and the 'postgres' user doesn't exist. The installer will
> create postgres as a 'locked' user account. Thats the reason
> you dont see 'postgres' listed as any other normal user.
> These steps were taken to enhance the security of the data folder.
>
>     Again, anytime a user is free to use any account as the
> service account and not use 'postgres'.
>
>     On 4/2/10 12:37 PM, John Gage wrote:
>
>         Then I don't understand why the installer
> doesn't do the same thing.
>
>         Or, in the alternative, why it doesn't ask you
> what you want these parameters to be.
>
>         I would say that, typically, someone installing
> postgres does it, conceivably, as root or, more likely, as a user.
>
>         What he or she doesn't do is install it as user
> 'postgres'.
>
>         Yet, that is what the one-click installer does.
>  I do not believe that this is intuitive.  What is more,
> gratuitiously adding a user to the system doesn't seem to
> make a whole lot of sense.
>
>         In addition, all other one-click installations
> on the Mac either don't ask for root privileges, because they
> don't need them, or ask for them, but still install under the
> current user.  Some installations will even ask whether you
> want the application usable by all users of the machine or just you.
>
>         But none, repeat none, create a new user.
>
>         What is more, through standard unix commands
> such as "who" or "cat /etc/passwd", I cannot find the user
> 'postgres' on my machine...even though he is the owner of the
> Postgres data files...on my machine.
>
>         There's the rub.  'postgres' owns files...my
> files...on my machine, yet he is not on my machine.  Not good.
>
>         I should add that I am an accolyte of Postgres
> and am only raising this (possible) issue in the most
> positive spirit I am capable of.  In addition, I think that
> the people on this list are superb, and the responses are
> unbelievably helpful and accurate.
>
>         John
>
>
>         On Apr 2, 2010, at 8:29 AM, John R Pierce wrote:
>
>
>
>             John Gage wrote:
>
>
>                 The 8.4.2 documentation says:
>
>                 "The default user name is your
> Unix user name, as is the default database name."
>
>
>
>             when you as a user connect to the
> database server the commands like psql, pg_dump, etc all use
> your unix username as the default for the database username,
> and your username as teh default for the database name,
> unless you specify a different user and/or database on hte
> command line.
>
>
>
>
>
>
>
>
>     --
>     Regards,
>     Sachin Srivastava
>     EnterpriseDB <http://www.enterprisedb.com> , the
> Enterprise Postgres <http://www.enterprisedb.com>  company.
>
>
>