Re: FATAL: role "postgres" does not exist

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-ports(at)postgresql(dot)org
Cc: Bob Middaugh <bob(dot)middaugh(at)comcast(dot)net>
Subject: Re: FATAL: role "postgres" does not exist
Date: 2007-08-16 16:27:53
Message-ID: 200708161827.54191.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports

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/

In response to

Browse pgsql-ports by date

  From Date Subject
Next Message Tom Lane 2007-08-16 16:28:51 Re: FATAL: role "postgres" does not exist
Previous Message Bob Middaugh 2007-08-16 16:09:23 FATAL: role "postgres" does not exist