Debian+PHP+PostgreSQL

For kicks (and out of a desire to prevent "monkey-trap-ism" — warning that's a PDF), I've been feeling like I need to move away from MySQL, and to that end, I'm trying out PostgreSQL for size.

I had some odd problems getting this set-up to work with PHP on Debian, so I thought I'd post my solution here, in the hopes that the next person to have this problem is more blessed by Google than I am. Of course, there's the "what I did" vs. "what, I now realize, I ought to have done all along".

Here's the "what I think should work better than what I did":

• sudo apt-get install php4 php4-pgsql phppgadmin
• Edit /etc/php4/apache(2)/php.ini and change your extension_dir to '/usr/lib/php/20020429' — I have no idea why that's the directory Debian chose to put these extensions in.
• Edit /etc/phppgadmin/apache.conf and allow your other systems — for me, this meant something like 'allow from 192.168.0.0/255.0.0.0'
• Copy or symlink this to your Apache configuration directory — for me, this meant copying & pasting this into /etc/apache2/sites-available/default
• Restart Apache.

At this point, you should be able to visit http://yourservername/phppgadmin/ in a browser and get a log in prompt.

Permalink • Posted in: tech stuff, linux, debian • Comments (5)