LART’s Blog

I know what the 3 of you who have my blog’s rss are thinking 2 posts in 1 day wtf?  well I finally come up with something to talk about.  This is related to my first post but it’s different enough that I’m making it a second post.

A number of people have requested that we use Postgresql instead of mysql.  At first I thought it was going to be a walk in the park after all the are both SQL… well I had never setup a dbms other then mysql and well postgresql has a LOT of options and is really diffrent from mysql.  The confusing file is pg_hba.conf mostly because there’s 9 different ways to  authenticate to the db server and you can set that differently for different hosts.  Then there’s the little differences.  If you want to quit you type \q if you want to list the tables you type \d if you want to see the structure of a table you type \d table_name.  Now I get to try and get php to work nicely with postgresql