Post Preview
postName: chrup
postWebsite: ''
postComment: "1. Create user postgres\n2. log in as root and build with:\n\nexport MACOSX_DEPLOYMENT_TARGET=10.7\nexport CC=gcc\nexport CPP=\"gcc -E\"\nexport CXX=g++\nexport CXXFLAGS='-O3 -fno-common -arch x86_64'\nexport CFLAGS='-O3 -fno-common -arch x86_64'\nexport LDFLAGS='-O3 -fno-common -arch x86_64'\n./configureprefix=/usr/local —enable-integer-datetimes —enable-thread-safet —with-libxml —with-libxslt —with-ossp-uuidwith-tclwith-perl —with-python —with-gssapi —with-krb5 —with-pamwith-ldap with-bonjourwith-openssl —with-zlib\n\nmake\nmake install\ncd contrib\nmake\nmake install\n\nsu - postgres\nexport PGDATA=/Users/postgres/data\ninitdb\n\nCreate this file:\n\n/Library/LaunchDaemons/org.postgresql.dbms.plist\n\nContent:\n\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<!DOCTYPE plist PUBLIC \"-Apple ComputerDTD PLIST 1.0//EN\"\n \"http://www.apple.com/DTDs/PropertyList-1.0.dtd\">\n<plist version=\"1.0\">\n<dict>\n <key>Label</key>\n <string>org.postgresql.dbms</string>\n <key>UserName</key>\n <string>postgres</string>\n <key>GroupName</key>\n <string>staff</string>\n <key>ProgramArguments</key>\n <array>\n <string>/usr/local/bin/postmaster</string>\n <string>-D</string>\n <string>/Users/postgres/data</string>\n </array>\n <key>RunAtLoad</key>\n <true/>\n</dict>\n</plist>\n\nStart Postgres server with:\n\nlaunchctl load /Library/LaunchDaemons/org.postgresql.dbms.plist \n\nStop the server with:\n\nlaunchctl unload /Library/LaunchDaemons/org.postgresql.dbms.plist \n\nworks great.\nStart when the machine starts\nNo issues.\nFast!\n"