PostgreSQL

Unknown in 10.8

Works fine in 10.7

PostgreSQL

Supports iCloud

Secured by Gatekeeper

Supports retina graphics

PostgreSQL icon

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

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>

Start Postgres server with:

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

Stop the server with:

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

works great.
Start when the machine starts
No issues.
Fast!

Edit | Permalink


[ chrup]chrupAnonymous 25 Jul 2012 02:31

Can't edit my post …

this should read:
'./configure —prefix'

and so on, got clobbered somehow …

Edit | Permalink

Lion (10.7) Comments

[ ]Anonymous 10 Jul 2011 04:14

Problem running post-install step. Installation may not complete correctly
The database cluster initialisation failed.

Edit | Permalink


[ Natalia]NataliaAnonymous 13 Jul 2011 21:20

I get the same message:

Problem running post-install step. Installation may not complete correctly La inicialización del clúster de la base de datos falló.

Edit | Permalink


Benjamin DellBenjamin DellAnonymous 21 Jul 2011 18:37

I'm hitting the same issue, has anyone found a work-around?

Edit | Permalink


[ larsvader]larsvaderAnonymous 27 Jul 2011 10:41

There seems to be a problem with the postgres user.
I've tried the Homebrew way of installing postgresql and had no problems.

https://github.com/mxcl/homebrew/wiki/installation

Edit | Permalink


[ Ian Mayo]Ian MayoAnonymous 04 Aug 2011 09:34

There seems to be a workaround described at:
http://www.azattis.com/2011/07/os-x-lion-postgresql-84-install-problem.html

Edit | Permalink


[ Javier]JavierAnonymous 07 Nov 2011 18:10

I am facing this problem on Windows XP… any clue?

Edit | Permalink

[[/module]]