See attached attached OneClick_PG_Installer notes.
Igor Neyman
> -----Original Message-----
> From: John Gage [mailto:jsmgage@xxxxxxxxxxxxxx]
> Sent: Friday, April 02, 2010 3:44 AM
> To: sachin.srivastava@xxxxxxxxxxxxxxxx
> Cc: pgsql-general@xxxxxxxxxxxxxx
> 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.
>
>
>
PostgreSQL 8.4
Usage:
--help Display the list of valid options
--version Display product information
--optionfile <optionfile> Installation option file
Default:
--unattendedmodeui <unattendedmodeui> Unattended Mode UI
Default: none
Allowed: none minimal minimalWithDialogs
--debuglevel <debuglevel> Debug information level of verbosity
Default: 2
Allowed: 0 1 2 3 4
--mode <mode> Installation mode
Default: win32
Allowed: win32 unattended
--debugtrace <debugtrace> Debug filename
Default:
--installer-language <installer-language> Language selection
Default:
Allowed: en es
--extract-only <extract-only>
Default: 0
--superaccount <superaccount> Sets the user name of the database superuser. Defaults to 'postgres'.
Default: postgres
--servicename <servicename> servicename.description
Default: postgresql-8.4
--serviceaccount <serviceaccount> Sets the operating system user account that owns the server process. Defaults to 'postgres'.
Default: postgres
--servicepassword <servicepassword> Sets the password for the operating system user account that owns server process. Defaults to superuser password.
Default:
--install_runtimes <install_runtimes> Specifies whether or not install the Microsoft Visual C++ runtimes before the installation proceeds.
Default: 1
--create_shortcuts <create_shortcuts> Specifies whether or not menu shortcuts should be created.
Default: 1
--prefix <prefix> Installation Directory
Default: C:\Program Files/PostgreSQL/8.4
--datadir <datadir> Data Directory
Default: C:\Program Files/PostgreSQL/8.4/data
--superpassword <superpassword> Password
Default:
--serverport <serverport> Port
Default: 5433
--locale <locale> Locale
Default:
--install_plpgsql <install_plpgsql> Install pl/pgsql in template1 database?
Default: 1
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
