X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C0C4153583 for ; Mon, 25 Apr 2005 19:18:51 -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 56850-07 for ; Mon, 25 Apr 2005 22:18:46 +0000 (GMT) Received: from smtp814.mail.sc5.yahoo.com (smtp814.mail.sc5.yahoo.com [66.163.170.84]) by svr1.postgresql.org (Postfix) with SMTP id E83C453589 for ; Mon, 25 Apr 2005 19:18:44 -0300 (ADT) Received: from unknown (HELO sys2) (shelece@sbcglobal.net@69.107.105.109 with login) by smtp814.mail.sc5.yahoo.com with SMTP; 25 Apr 2005 22:06:54 -0000 Reply-To: From: "bruce" To: Subject: starting/running postgres... Date: Mon, 25 Apr 2005 15:09:11 -0700 Message-ID: <04b401c549e3$693ee2e0$0301a8c0@Mesa.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 9.0, Build 9.0.2910.0 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.267 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200504/24 X-Sequence-Number: 3108 hi. i'm installing postgres and have a few questions... i can login/su as the user 'postgres' and then 'postmaster -i -p 5432 -D /var/lib/psql/data/'. this starts the postgres app, and i can access it from a website. however, if i attempt to do 'service postgresql start' while i'm 'root', the postgres db/app still starts, but i'm unable to connect to it from the website. the same thing occurs if i try to start the postgres app from the 'gnome' gui... the website tries to access the db as user 'gforge'. this user is different than the user 'postgres' or the user 'root'. as i said, this works if i start postegres from the command line as user 'postgres'. any ides/thoughts/etc... thanks bruce bedouglas@earthlink.net ps. im unable to use the 'services postgresql start' as user 'postgres'.