Re: [PORTS] FATAL: role "postgres" does not exist

Peter Eisentraut <[email protected]> Thu, 16 Aug 2007 18:27:53 +0200
Newsgroups gmane.comp.db.postgresql.ports
Message-ID <[email protected]>
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 "postgr=
es"
> does not exist
>
> I don't know what it's looking for. =A0When you install the server from
> ports, it creates the user "pgsql" in /etc/passwd.=20

You need to convince your OpenNMS to use the right user, or you need to r=
ename=20
your pgsql user, or you create a postgres superuser.

--=20
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings