Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'Automatically start PostgreSQL at boot' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Automatically start PostgreSQL at boot
Authored by: kyngchaos on Apr 19, '05 11:30:51AM

I recently created an installer package for Postgres, and included a modified version of the Liyanage startupitem. Postgres v8.0.1 (I haven't looked at 8.0.2 yet), and also includes PostGIS extension (for use in MapServer and GRASS). It sets up the postgres user and starts it up.

I'll have to work on 8.0.2 this week. And - oops - I had the hostconfig thing setup up for post install, but that didn't make it into my package.

One note on your startupitem - startup items already run as root, so there's no need for sudo.

I've been kinda lazy - I should add it to VersionTracker. http://webpages.charter.net/kyngchaos/macosx/downloads.html



[ Reply to This | # ]
Automatically start PostgreSQL at boot
Authored by: trollll on Apr 19, '05 07:47:43PM

you might want to contribute to the postgresql for mac project on sourceforge: http://sourceforge.net/projects/pgsqlformac/

today, i installed postgresql, a startup item, the jdbc driver and a handful of gui tools for managing. extremely easy to install! but they would most likely not turn down a helping hand.



[ Reply to This | # ]
Automatically start PostgreSQL at boot
Authored by: geofstro on Oct 29, '05 10:51:25AM

Under OS X Tiger Apple has implemented LaunchD for starting Daemons.

I found the following link for creating a LaunchD .plist for postgreSQL

http://openacs.org/blog/archive/2005/06/

Look under 'PostgreSQL Launchd on Tiger'

I needed to change a couple of things though.

1/ This .plist needs to be installed in /System/Library/LaunchDaemons/
NOT /Library/LaunchDaemons/
2/ Make sure you alter the GroupName at the end of the .plist to agree with the group name the postgres user belongs to on your system.

Once these have been taken care of, this is all you will need to start postgreSQL on system bootup.

Hope it helps



[ Reply to This | # ]
Automatically start PostgreSQL at boot
Authored by: psychoacoustic on May 17, '06 04:21:37PM
/ This .plist needs to be installed in /System/Library/LaunchDaemons/ NOT /Library/LaunchDaemons/

This is absolutely wrong. Per Apple's Getting Started with launchd page, only Apple launchd jobs should ever be installed under /System/Library. In fact, /System as a whole is reserved for Apple use, which is why they provide two places for non-Apple app data and configuration: /Library for system-wide data and ~/Library for user-specific data.

If the launchd script in question wasn't working in /Library/LaunchDaemons, I expect there was some other problem at work. Check out the Apple doc above for more info and links to other Apple system startup documentation.



[ Reply to This | # ]