In response to Ben Trewern :
> Using th new postgresql 8.4.0 (compiled)
> On Ubuntu 8.10
>
> I did an initdb, added a password to the postgres user and then
> changed the pg_hba.conf to:
>
> local all all md5
> host all all 127.0.0.1/32 md5
>
> Restarted Postgresql.
>
Using th new postgresql 8.4.0 (compiled)
On Ubuntu 8.10
I did an initdb, added a password to the postgres user and then
changed the pg_hba.conf to:
local all all md5
host all all 127.0.0.1/32 md5
Restarted Postgresql.
If I log in normally:
postg...@ben-desktop:~$ psq