PostgreSQL

Supports iCloud

Secured by Gatekeeper

Supports retina graphics

Available on the Mac App Store
Not available on the Mac App Store

You have to build it from source in 32 or 64 bit mode. There are no compile issues. Even the contrib modules compile fine. You cannot build FAT binaries (more than one architecture). The client library libpq can be built with both, i386 and x86_64 architecture which then allow the build of the relevant FAT PHP modules. No issues in Lion (any version).

Version	9.1.4
Developer
Website	http://www.postgresql.org/
Status	Unknown

0 ratings

Versions

Feature support

Lion
Versions	Supports Versions
Auto save	Supports Auto Save
Resume	Supports Resume
Fullscreen	Supports Fullscreen

Mountain Lion
Notification Center	Supports Notification Center
iCloud	Supports iCloud
Gatekeeper	Supports Gatekeeper
Retina graphics	Supports Retina graphics

Notes

Build from source in 64-bit mode. All versions from 9.0.0 to 9.1.4 work fine.

Archived comments

No comments.8 comments

[ chrup]chrupAnonymous 25 Jul 2012 02:28

1. Create user postgres
2. log in as root and build with:

export MACOSX_DEPLOYMENT_TARGET=10.7
export CC=gcc
export CPP="gcc -E"
export CXX=g++
export CXXFLAGS='-O3 -fno-common -arch x86_64'
export CFLAGS='-O3 -fno-common -arch x86_64'
export LDFLAGS='-O3 -fno-common -arch x86_64'
./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

make
make install
cd contrib
make
make install

su - postgres
export PGDATA=/Users/postgres/data
initdb

Create this file:

/Library/LaunchDaemons/org.postgresql.dbms.plist

Content:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-Apple ComputerDTD PLIST 1.0//EN"
"http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>Label</key>
<string>org.postgresql.dbms</string>
<key>UserName</key>
<string>postgres</string>
<key>GroupName</key>
<string>staff</string>
<key>ProgramArguments</key>
<array>
<string>/usr/local/bin/postmaster</string>
<string>-D</string>
<string>/Users/postgres/data</string>
</array>
<key>RunAtLoad</key>
<true/>
</dict>
</plist>