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
/Library/PostgreSQL/8.4/data
/Applications/PostgreSQL\ 8.4
open /Applications/PostgreSQL\ 8.4/Stop\ Server.app
open /Applications/PostgreSQL\ 8.4/Start\ Server.app
open /Applications/PostgreSQL\ 8.4/Restart\ Server.app
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
/opt/local/var/db/postgresql84/defaultdb
/opt/local/etc/LaunchDaemons/org.macports.postgresql84-server/
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
/usr/local/pgsql/bin/initdb
/usr/local/pgsql/data
/usr/local/pgsql/data/pg_hba.conf
Article 1
Article 2
thread troubleshooting from source
Topic revision: 03 Aug 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