X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7C3D1D1B1B6 for ; Mon, 21 Jun 2004 22:27:12 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31323-02 for ; Tue, 22 Jun 2004 01:27:07 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4E3DED1B193 for ; Mon, 21 Jun 2004 22:27:02 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i5M1Qc45008581; Mon, 21 Jun 2004 21:26:38 -0400 (EDT) To: "lise chhay" Cc: pgsql-admin@postgresql.org Subject: Re: In-reply-to: <20040621161443.C3DA24BDAC@ws1-1.us4.outblaze.com> References: <20040621161443.C3DA24BDAC@ws1-1.us4.outblaze.com> Comments: In-reply-to "lise chhay" message dated "Mon, 21 Jun 2004 11:14:43 -0500" Date: Mon, 21 Jun 2004 21:26:37 -0400 Message-ID: <8580.1087867597@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/286 X-Sequence-Number: 13946 "lise chhay" writes: > J have created the user auth under Unix and I did : > # su - postgres > postgres$ createuser auth > User auth created > postgres$ psql auth > auth=# INSERT INTO groupes (groupe, descr) VALUES ('auth', 'Administrateurs de la base Auth') ; > auth=# INSERT INTO utilisateurs (login, password, nom, prenom) VALUES ('auth', 'tnnxiPQeNdFYs', 'auth', 'auth') ; > auth=# INSERT INTO membres (login, groupe) VALUES ('auth', 'auth') ; You have not set a Postgres password for this user. (I don't know what "utilisateurs" is, but it's definitely not what Postgres will consult.) Use the ALTER USER command to set the correct password. regards, tom lane