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: debian, linux, tech stuffComments (2)

Comments

Joshua Feb 22, 2006

Hey, it's not my fault if some people are antsy. I have a little write-up here.

Joshua Feb 22, 2006

Ah, and the caricature was drawn at GenCon 2005 by an artist who's name I can't remember anymore.