Postgres on Mac

Troubleshooting assumes familiarity with
  • postgres basics from the wiki page PostgreSQL and any issues already on TroubleshootingPostgreSQL?
  • database bootstrapping and updating (and logging of same) as depending on a combination of
    • bash shell scripts
    • python with modules installed and within the $PATH
    • postgres installed, with any needed binaries within the $PATH
      • export PATH=$PATH:/Library/PostgreSQL/8.4/bin/ for EnterpriseDB
      • export PATH=$PATH:/opt/local/lib/postgresql84/bin for MacPorts

Verify that a system user postgres exists, e.g.
  • by querying the MacOS directory service for the NFSHomeDirectory: /usr/bin/dscl . -read /users/postgres
  • or parse its UniqueID:
    /usr/bin/dscl . -read /users/postgres | grep "^UniqueID:.[0-9]" | sed 's/.*: //' | sed 's/ //'

Take into account factors that may be related to your postgres distributions (below) and – if relevant – be prepared to supply a bootstrap or update log file in […]/gnumed/server/bootstrap/.

Distribution Paths, Commands URLs Comments
Enterprise DB /Library/PostgreSQL/8.4/bin
/Applications/PostgreSQL\ 8.4
open /Applications/PostgreSQL\ 8.4/Stop\
open /Applications/PostgreSQL\ 8.4/Start\
open /Applications/PostgreSQL\ 8.4/Restart\
Download URL Version 8.4.0-1 (51 Mb);
extra binaries
Uninstall seems to leave behind only [{…]/data and system user postgres
MacPorts /opt/local/lib/postgresql84/bin
Project home Marc Chung's notes
nice post on postgres 8.3 in MacPorts
upgrading postgres 8.3 --> 9
thread troubleshooting port install
PostgreSQLforMac /Library/PostgreSQL8/bin
caveat: under migration to /Library/PostgreSQL/bin
Project home  
Misc & source /usr/local/postgresql-8.4.4
Article 1
Article 2
thread troubleshooting from source
Topic revision: 03 Aug 2011, JamesBusser
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