PostgreSQL on OSX

PostgreSQL OS X

portでインストールしたときのメッセージ



###########################################################

# A startup item has been generated that will aid in

# starting postgresql82-server with launchd. It is disabled

# by default. Execute the following command to start it,

# and to cause it to launch at startup:

#

# sudo launchctl load -w /Library/LaunchDaemons/org.macports.postgresql82-server.plist

###########################################################



    

  • 

      

    • 

        

      • >  Deactivating postgresql82-server 8.2.6_0
        • 

      • >  Installing postgresql82-server 8.2.9_0
        • 

      • 

    • 

To create a database instance, after install do

 sudo mkdir -p /opt/local/var/db/postgresql82/defaultdb

 sudo chown postgres:postgres /opt/local/var/db/postgresql82/defaultdb

 sudo su postgres -c '/opt/local/lib/postgresql82/bin/initdb -D /opt/local/var/db/postgresql82/defaultdb'
To tweak your DBMS, consider increasing kern.sysv.shmmax by adding an increased kern.sysv.shmmax .. to /etc/sysctl.conf