Archive for January 26th, 2009

Quick PostgreSQL setup

January 26th, 2009 No comments

This is yet another one of those things I really don’t do all that often. So infrequently in fact that I forgot I had manipulated a config file when I originally setup my machine. I just updated my Ubuntu distro and with that came an updated verson of postgres (8.3) and of course my setup stopped working. The simple edit I have setup may not be safe, but it’s for a development machine so I really don’t think it matters. Here’s a quick way to get your Postgres DB setup…

Go to the bottom of your pg_hba.conf file which is found in /etc/postgresql/8.x/main/ and make changes to the settings so they match the following.

local   all         all                               trust
host    all         all          trust
host    all         all         ::1/128               ident sameuser

Then restart the postgres server.

/etc/init.d/postgresql-8.x restart

Categories: PostgreSQL Tags: