X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 16047D1B911 for ; Tue, 6 Apr 2004 15:43:53 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 87548-08 for ; Tue, 6 Apr 2004 15:43:52 -0300 (ADT) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 630B1D1B890 for ; Tue, 6 Apr 2004 15:43:51 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i36IikcM003114; Tue, 6 Apr 2004 14:44:46 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i36Ihll15085; Tue, 6 Apr 2004 14:43:50 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id FVMA7NCD; Tue, 6 Apr 2004 14:43:45 -0400 Subject: Re: Problem From: Robert Treat To: Lukasz Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 06 Apr 2004 14:43:47 -0400 Message-Id: <1081277027.31791.84.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/94 X-Sequence-Number: 13067 On Tue, 2004-04-06 at 11:06, Lukasz wrote: > Hello > > I have installed PostgreSQL on Red Hat 9 . I have a problem: I have > added new user of the database system , the name of this user is : > "jan" . I have given him > the permission for creating new databases and for adding new users, > but when I > wrote: > > psql -U jan template1 > > then I have got message: > > psql : FATAL : IDENT authentication failed for user "jan" . > > > What is wrong ? What should I do with it ? > IDENT authentication requires (generally) that your system user be the same as your database user. Since it sounds like this is not what you want, you need to modify your pg_hba.conf file and change the settings as appropriate. (See comments in the file or docs for specifics on the different options) Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL