This site is packed with information about running PostgreSQL on the Mac: http://www.entropy.ch/software/macosx/postgresql/
On this page you will find a package installer for PostgreSQL (it looks like you already have it installed, but maybe not correctly) and a startup item that can be used to start the server when the machine boots up.
As far as making a double clickable app to start and stop the database, my suggestion would be to write a simple shell script that will do it (could be as easy as writing how you currently start it to a file called pgstop.sh) and then using Platypus (http://sveinbjorn.vefsyn.is/platypus) to make it double clickable.
As far as the errors you are having, it's really hard to tell unless we know how it was installed. It could be how you are starting the application, how it was installed, a user setting problem, etc. If you could send the log, it might be more helpful. If you use the package installer from above and follow all of the directions, you should be ok.
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Adam I. Harris,
Sent: Friday, October 15, 2004 7:07 AM
Subject: [NOVICE] Getting Started
While I consider myself computer literate, I don't speak "server". I
have an XServe running Mac OS 10.3. The dual G4 machine has 2 Gig RAM
and 750 GIG hard drive. I'm using a PACS program that depends on
Postgresql to run my image database. For the life of me, I cannot get
postgresql to install and run properly. I get errors in the log that
access to certain files is denied on the basis of permissions, while I
cannot find the files in question to grant access (yes, I do know how
to look for invisible files).
I really could use some assistance getting the system started. I also
will need a clickable icons and two programs to start and stop the db
with auto start on reboot.
I've been trying to install 7.4.3. Is version 8 ready for prime time?
Any and all help is greatly appreciated.
Adam I. Harris, M.D.
San Antonio Orthopaedic Specialists
Specializing in Joint Replacement of the Hip, Knee, and Shoulder
First in South Texas to offer the Zimmer Minimally Invasive Total Hip
replacement and Minimally Invasive Total Knee replacement.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2004-10-15 14:29:26|
|Subject: Re: Two table joins |
|Previous:||From: Adam I. Harris, M.D.||Date: 2004-10-15 11:06:31|
|Subject: Getting Started|