> I just tried with 8.4.1. Started with the default configuration, created
> data/pg_ident.conf with:
> pg_map root postgres
> pg_map postgres postgres
>
> Replaced in pg_hba.conf:
> < local all all trust
> by
>> local all all ident map=pg_map
>
> Restarted the server, and then:
> $ su -
> # /usr/local/pg84/bin/psql -U postgres
> psql (8.4.1)
> Type "help" for help.
>
> postgres=#
>
> ... it appears to works.
>
I am sad to report that this does not work with ubuntu 9.04 postgres
8.3 installed from the packages. I have removed everything from
pg_hba.conf except for the one line what says
local all all ident map=pg_map
My pg_ident /etc/postgres/8.3/main/pg_ident.conf file says
pg_map root postgres
pg_map postgres postgres
When I restart postgres and type
psql -U postgres
psql: FATAL: Ident authentication failed for user "postgres"
If I replace the line in pg_hba.conf with this.
local all all trust
It works.
the "ident_file" setting in postgresql.conf is pointing to the right file.
At this point I am going to go with the trust method and go on with my project.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general