29
Note that with PostgreSQL 9.0 (and probably newer) on Mac OS 10.6.8 (and probably older), in order to prevent the PostgreSQL server from auto-starting, you have to:
- Go to
/Library/LaunchDaemons/
- Open
com.edb.launchd.postgresql-9.0.plist
in an editor asroot
(replace9.0
with your correct version number), e.g.sudo vim com.edb.launchd.postgresql-9.0.plist
. - Locate the line
<key>RunAtLoad</key>
- Change the next line from
<true/>
to<false/>
- Save and exit.
That should do it. Also, if you want to stop the server immediately, without restarting, su
to postgres
and run /Library/PostgreSQL/9.0/bin/pg_ctl stop -D<your data dir>
. You can find out which is your current data dir with ps aux|grep postgre
.
Source: http://forums.enterprisedb.com/posts/list/2240.page#8321