For the ident issue after installation you can change the method of authentication.. for ex:
in /etc/postgresql/8.3/main/pg_hba.conf .. the last section can be changed to:
------------------------------------------------------
local all postgres trust
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
For the ident issue after installation you can change the method of authentication.. for ex:
in /etc/postgresql /8.3/main/ pg_hba. conf .. the last section can be changed to: ------- ------- ------- ------- ------- ------- -----
-------
local all postgres trust
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5