Filed under: postgres
Today, I’ve been trying to get PsycoPG2 installed on my Macbook so that I can run through some tests and try and improve the user experience on Who’s Playing and hopefully increase it’s usage. I re-installed OSX the other week, and there’s still some little things like this to catch.
First off, I tried installing it via Macports, which worked Ok, but didn’t install it in a directory that the default Apple install of Python could see, it put it in the Macports directory. After a while I couldn’t find any way to change the install dir, so I ran:
which lost all my other libraries, and the Django framework. Not quite what I wanted really.
Will switch you back to the Apple install.
The easiest thing to do is just to download the latest psycopg2 tarball, and edit the setup.cfg file. I also installed Postgres from the official Mac binary, not from Macports, so I told it to use pg_config from that install. Uncomment the pg_config line and point it to your install of Postgres.
Then run setup.py
sudo python setup.py install
Update: For Snow Leopard users, you might also see the following error:
Symbol not found: _PQbackendPID
The solution, that I found on Kreegers blog, is to tell Snow Leopard that python needs to run in 32bit mode:
defaults write com.apple.versioner.python Prefer-32-Bit -bool yes
So I spent most of last night trying to figure out why the hell Mark, the webmaster of www.automatedhome.co.uk couldn’t add any new stories. Well I’ve had it with PHPNuke, how it’s lasted so long is beyond me.
I’ve been wanting to do something meaningfull with Bricolage for a long time (and secretly thought AHUK was a good candidate. I even did a few mock ups and wrote a migration script from the AHUK db to a format that Bricolage could import. The project never made it past that though, I always had something better to do. After last nights little escapade though, I think I’ll make time …
The first problem to overcome is Bricolage’s slightly different system architecture. Itis recommended that the admin function is carried out on a different server to the front end server. Also the admin server needs to run on Apache 1.3 due to it’s dependencies.
That’s where Damn Small Linux hopefully comes in. It’s only 50M or so, and you can run it right from inside Windows . Installation is dead simple, just download it, unzip it and run Syslinux on it.
Next to get Apache installed.