X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id EC82A9FB393 for ; Fri, 4 Aug 2006 12:57:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 75173-02 for ; Fri, 4 Aug 2006 15:57:24 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.184]) by postgresql.org (Postfix) with ESMTP id C56A09FB1DE for ; Fri, 4 Aug 2006 12:57:23 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id a27so41588nfc for ; Fri, 04 Aug 2006 08:57:22 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=LzHHOYXleuIh+X0zafthKnA1/7Z+NXUoR1Ab7h+83qV7sF8pE8rNhDW91Wzg9yBi16EcPwdfiUHRP8NRIFn2Ms9/DIdj6WTZxtXoTz0Yyz6bhpeFApUf/zLot2EYS7v5lT2zGdBkFxwdXt50nPnAo/t/6MFNeJQ01JgI/UYnEiM= Received: by 10.49.91.6 with SMTP id t6mr5474739nfl; Fri, 04 Aug 2006 08:57:22 -0700 (PDT) Received: by 10.35.95.5 with HTTP; Fri, 4 Aug 2006 08:57:22 -0700 (PDT) Message-ID: <4b315f820608040857g2193dfb3gdbccb810be5c9d22@mail.gmail.com> Date: Fri, 4 Aug 2006 12:57:22 -0300 From: "Rodolfo Borges" To: pgsql-admin@postgresql.org Subject: installing on user account MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.199 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/41 X-Sequence-Number: 22585 I don't have root access here at work, and I wanted to run a jabber server to communicate with other folks here. I choose PostgreSQL as db backend. It is already installed, but it's not starting on boot. I don't have the password for the postgres user, so I'm running the postmaster daemon as my own user. $export PGDATA=$HOME/usr/var/postgres $initdb these went ok. Then I started following the jabberd2 installation instructions from here: http://jabberd.jabberstudio.org/2/docs/section04_5.html They said "createdb -U postgres -E UNICODE jabberd2", I ran "createdb -E UNICODE jabberd2" instead. Then "createuser -P -U postgres jabberd2", I ran "createuser -P jabberd2". No problem so far. Next step would be to run psql to issue a \i command to setup the jabberd2 database. They said "psql -U jabberd2 jabberd2", but I received the following error: $psql -U jabberd2 jabberd2 psql: FATAL: IDENT authentication failed for user "jabberd2" I also tried appending a -W argument to that command. It asked for the password, I gave the password from the createuser command, and the same error ocurred. If I enter with my own user (psql jabberd2), and issue a \du, I see: User name | User ID | Attributes -----------+---------+---------------------------- jabberd2 | 100 | nttx | 1 | superuser, create database (2 rows) My setup: $postgres --version postgres (PostgreSQL) 7.3.6-RH $cat /etc/redhat-release Red Hat Enterprise Linux WS release 3 (Taroon Update 2) $uname -a Linux 2.4.21-15.ELsmp #1 SMP Thu Apr 22 00:09:01 EDT 2004 x86_64 x86_64 x86_64 GNU/Linux Any ideas? Well, I have one: I'll to install PostgreSQL on my account, and run that instead. -- Rodolfo Borges