Hi: We have installed postgresql82 using Fink. The instructions I get when I do describe are:
> Usage Notes: > The package runs initdb on installation as the user 'postgres'. > . > The best way to run it is using the supplied pgsql.sh script, i.e. > 'sudo pgsql.sh start'. Or, you can run > 'sudo daemonic enable postgresql82' as root to create a > StartupItem for it. > . > Unless you set up admin users in the database, the easiest way to > run psql commands with administrator access is to prefix them with > the command "sudo -u postgres". This will ask you your administrator > password, and then run the command as the postgres user. > . > For example, to create a new database, you would run: > . > sudo -u postgres createdb mydb > > Even if it has to be started by an admin user, we would like new databases to be created and modified by a non-admin user (i.e so sudo does not need to be used to create the database). Or should I require sudo and modify the sudoers file? Any info appreciated. -Roy M. ********************** "The contents of this message do not reflect any position of the U.S. Government or NOAA." ********************** Roy Mendelssohn Supervisory Operations Research Analyst NOAA/NMFS Environmental Research Division Southwest Fisheries Science Center 1352 Lighthouse Avenue Pacific Grove, CA 93950-2097 e-mail: [EMAIL PROTECTED] (Note new e-mail address) voice: (831)-648-9029 fax: (831)-648-8440 www: http://www.pfeg.noaa.gov/ "Old age and treachery will overcome youth and skill." ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Fink-users mailing list Fink-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/fink-users