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.
|
