Re: "1-Click" installer problems

Yes you need to re-install.. (uninstall and install again).
You can point the new installation to the old data directory if you want..

On 4/2/10 4:25 PM, John Gage wrote:
> 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 <http://www.enterprisedb.com>, the Enterprise Postgres
>>>> <http://www.enterprisedb.com> company.
>>>
>>
>>
>> --
>> Regards,
>> Sachin Srivastava
>> EnterpriseDB <http://www.enterprisedb.com>, the Enterprise Postgres
>> <http://www.enterprisedb.com> company.
>

--
Regards,
Sachin Srivastava
EnterpriseDB <http://www.enterprisedb.com>, the Enterprise Postgres
<http://www.enterprisedb.com> company.