Re: "1-Click" installer problems

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.