Enterprise Db

The following was used for Mac OS 10.6.4 Snow Leopard

EnterpriseDb offers (for multiple platforms including Mac)

Installer version Version 8.4.8-1

which is what I chose. You may need to register. On installing, you may be notified one of the following:

If this is your first time installing the Enterprise db version: "Your shared memory configuration has been adjusted with new settings in /etc/sysctl.conf. Please reboot the system to allow the new settings to take effect and re-run the installer. If you wish to restore the default settings in the future, simply delete /etc/sysctl.conf and reboot. "

If you uninstalled with the option to leave data intact, and are now reinstalling, you may be given a similar warning except you may have to manually adjust the relevant file.

(reboot and re-run the installer, accepting the defaults except optionally to set a password [do not lose!] and to specify the default locale)

Please specify the directory where PostgreSQL will be installed.
/Library/PostgreSQL/8.4 (accept)

Please select a directory under which to store your data.
/Library/PostgreSQL/8.4/data (accept)

Please provide a password for the database superuser (postgres). A locked Unix user account (postgres) will be created if not present.
---> leave blank, or set as postgres (or as something better)
---> leave blank, or set as postgres (or as something better)

Please select the port number the server should listen on.
[default 5432] (accept)

Select the locale to be used by the new database cluster
[Default locale] ---> I set this to en_CA

Install pl/pgsql in template1 database?
[ default yes ] (accept)

Setup is now ready to begin installing PostgreSQL on your computer
(click)

Installing...
(progress thermometer)

... option post-exit whether to run Enterprisedb's Stack Builder app
(declined)

reference ...
************************************************************
Enterprise Db version of these instructions
   http://www.enterprisedb.com/learning/pginst_guide.do#noninteractive

Daemons
   /Library/LaunchDaemons/com.edb.launchd.postgresql-8.4.plist

Command line to start
   su - postgres -c \"/Library/PostgreSQL/8.4/bin/pg_ctl start -w -D /Library/PostgreSQL/8.4/data\"

Scripts to start, stop
   /Library/PostgreSQL/8.4/scripts/start.applescript
   /Library/PostgreSQL/8.4/scripts/stop.applescript

Binaries in
   /Library/PostgreSQL/8.4/bin

pgAdmin3 app located in
   /Library/PostgreSQL/8.4/
   (connect to template1 to demonstrate all is working)

A post on uninstalling
   http://forums.enterprisedb.com/posts/list/1437.page
************************************************************

-- Jim
Topic revision: 24 May 2011, JamesBusser
 
Download.png
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Foswiki? Send feedback
Powered by Olark