Hi Adrian, Thanks for the reply. My pg_hba.conf have this: [code] # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all ident # IPv4 local connections: host all all 127.0.0.1/32 ident # IPv6 local connections: host all all ::1/128 ident [/code] Some clue with this config file? Best Regards, On Fri, Dec 2, 2011 at 11:34 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote: > On Friday, December 02, 2011 3:13:41 pm Andre Lopes wrote: >> Hi, >> >> I've installed PostgreSQL 9.0 in CentOS6 I don't have configured >> anything in Postgre, I just created a user with this method: >> > >> >> With the method above I have no problems in enter "psql" but when I >> try to connect with the user created with these method to a webapp I >> got an error: >> >> [code] >> Exception Value: >> FATAL: Ident authentication failed for user "mypoatgreuser" >> [/code] >> >> There is more permissions that I must to give to the user >> "mypoatgreuser"? What could be wrong here? > > Some pointers. The client authentication is handled here: > http://www.postgresql.org/docs/9.0/interactive/auth-pg-hba-conf.html > > In your pg_hba.conf there is at least one authentication method set to ident. > That is described here: > http://www.postgresql.org/docs/9.0/interactive/auth-methods.html#AUTH-IDENT > > From the sequence of commands you have given you are looking to use password > authentication. For security you want md5. > There may already be a line with that method in your pg_hba.conf. In pg_hba.conf > first matching line wins, so if there is a line with ident first it will take > precedence. > > If this is too confusing post your pg_hba.conf(unless of course there are > security issues) and we can go from there. > > >> >> Best Regards, > > -- > Adrian Klaver > adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
