Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7B5969F985C for ; Thu, 16 Aug 2007 13:28:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 41794-04 for ; Thu, 16 Aug 2007 13:28:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gauss.credativ.com (gauss.credativ.com [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id DFDBB9F9809 for ; Thu, 16 Aug 2007 13:28:01 -0300 (ADT) Received: from hawking.credativ.lan (exit.credativ.com [87.139.82.80]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 16F75776BE; Thu, 16 Aug 2007 18:22:38 +0200 (CEST) From: Peter Eisentraut To: pgsql-ports@postgresql.org Subject: Re: FATAL: role "postgres" does not exist Date: Thu, 16 Aug 2007 18:27:53 +0200 User-Agent: KMail/1.9.5 Cc: Bob Middaugh References: <081620071609.24745.46C476B3000B68DF000060A9221352857308099A0E0B0B0703D20D010D@comcast.net> In-Reply-To: <081620071609.24745.46C476B3000B68DF000060A9221352857308099A0E0B0B0703D20D010D@comcast.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Content-Disposition: inline Message-Id: <200708161827.54191.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/11 X-Sequence-Number: 2575 Am Donnerstag, 16. August 2007 18:09 schrieb Bob Middaugh: > Exception in thread "main" org.postgresql.util.PSQLException: Backend > start-up failed: org.postgresql.util.PSQLException: FATAL: role "postgres" > does not exist > > I don't know what it's looking for.  When you install the server from > ports, it creates the user "pgsql" in /etc/passwd. You need to convince your OpenNMS to use the right user, or you need to rename your pgsql user, or you create a postgres superuser. -- Peter Eisentraut http://developer.postgresql.org/~petere/