Re: "1-Click" installer problems

I am incredibly interested in this.

In the first place, I did not load postgres from the command line as
you do here. I double-clicked. I also do not remember seeing the
usage options.

That being said, now that I have downloaded and installed the system,
how can I change:

>
> --serviceaccount <serviceaccount> Sets the operating system user
> account that owns the server process. Defaults to 'postgres'.
> Default: postgres

Or, in fact, must I re-install to change this? It looks like I have
to re-install.

Thank you very much for responding to my questions. I truly
appreciate it. Your support is welcome and superb.

John

On Apr 2, 2010, at 9:52 AM, Sachin Srivastava wrote:

> Thats what i get:
>
> edbs-MacBook:~ sachin$ hdiutil attach postgresql-8.4.3-1-osx.dmg
> expected CRC32 $F9B026D4
> /dev/disk1 Apple_partition_scheme
> /dev/disk1s1 Apple_partition_map
> /dev/disk1s2 Apple_HFS /Volumes/
> PostgreSQL 8.4.3-1
> edbs-MacBook:~ sachin$ sudo /Volumes/PostgreSQL\ 8.4.3-1/
> postgresql-8.4.3-1-osx.app/Contents/MacOS/installbuilder.sh --help
> Password:
> 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: qt
> Allowed: qt osx text 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
>
> --create_shortcuts <create_shortcuts> Specifies whether or not menu
> shortcuts should be created.
> Default: 1
>
> --prefix <prefix> Installation Directory
> Default: /Library/PostgreSQL/8.4
>
> --datadir <datadir> Data Directory
> Default: /Library/PostgreSQL/8.4/data
>
> --superpassword <superpassword> Password
> Default:
>
> --serverport <serverport> Port
> Default: 5432
>
> --locale <locale> Locale
> Default:
>
> --install_plpgsql <install_plpgsql> Install pl/pgsql in template1
> database?
> Default: 1
>
>
> On 4/2/10 1:14 PM, John Gage wrote:
>>
>> 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, the Enterprise Postgres company.
>>
>
>
> --
> Regards,
> Sachin Srivastava
> EnterpriseDB, the Enterprise Postgres company.