2011. július 23., szombat

OS X Lion PostgreSQL 8.4 install problem

Actually i've runed into two different problems. 

The first one occured right after installation which was unsuccesfull. I've cheked the installation log in /tmp directory and i realized that postgres user was not created and data directory does not exist, as it should in /Library/PostgreSQL/8.4 dir. But everything else was in place so it's possible to fix perfectly after some fumbling:  

You have to add postgres user manually at System Preferences. Then as root:

cd /Library/PostgreSQL/8.4
mkdir data
chmod 700 data
chown postgres data
su postgres
/Library/PostgreSQL/8.4/bin/initdb /Library/PostgreSQL/8.4/data
Then it's possible to start up the database server:

/Library/PostgreSQL/8.4/bin/pg_ctl start -D /Library/PostgreSQL/8.4/data/

The second error came after restart when the built in apache was unable to start up. I've checked my configuration in Terminal app as root:

sudo apachectl -S
dyld: Library not loaded: /usr/lib/libpq.5.dylib
  Referenced from: /usr/sbin/httpd
  Reason: no suitable image found.  Did find:
/usr/lib/libpq.5.dylib: no matching architecture in universal wrapper

The solution was to relink /usr/lib/libpq.5.lib:

sudo rm /usr/lib/libpq.5.lib
sudo ln -s /usr/lib/libpq.5.3.dylib /usr/lib/libpq.5.dylib


That's all so far.. and it works :)

Nincsenek megjegyzések:

Megjegyzés küldése