Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-ports by date

Next:From: Tom LaneDate: 2007-08-16 16:28:51
Subject: Re: FATAL: role "postgres" does not exist
Previous:From: Bob MiddaughDate: 2007-08-16 16:09:23
Subject: FATAL: role "postgres" does not exist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group