> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
