Hosting Provided By

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

From: Bob Middaugh <bob.middaugh(at)comcast.net>
Date: Thu Aug 16 2007 - 12:09:23 EDT

Hi all,
Back again with another FreeBSD 'centric question. I'm running the OpenNMS installer which "configures PostgreSQL tables, users, and other miscellaneous settings."

It bombs with this:

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.

How do I get the "role" postgres? Is that a role in Postgresql that I need to create?

opennms# sh install -disU

OpenNMS Installer Version $Id: Installer.java 3056 2006-03-26 19:39:16Z djgregor $

Configures PostgreSQL tables, users, and other miscellaneous settings.

Exception in thread "main" org.postgresql.util.PSQLException: Backend start-up failed: org.postgresql.util.PSQLException: FATAL: role "postgres" does not exist

        at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnectionV3(AbstractJdbc1Connection.java:460)
        at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:214)
        at org.postgresql.Driver.connect(Driver.java:139)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.opennms.install.Installer.databaseConnect(Installer.java:613)
        at org.opennms.install.Installer.install(Installer.java:195)
        at org.opennms.install.Installer.main(Installer.java:2450)

Do you need help?

Any suggestions?

Thanks,
Bob

---------------------------(end of broadcast)---------------------------

TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq Received on Thu Aug 16 12:11:14 2007

This message: [ Message body ]
Next message: Peter Eisentraut: "Re: [PORTS] FATAL: role "postgres" does not exist"
Previous message: Bob Middaugh: "Re: [PORTS] Postgresql server src files for 8.1.4 on FreeBSD"
Next in thread: Peter Eisentraut: "Re: [PORTS] FATAL: role "postgres" does not exist"
Reply: Peter Eisentraut: "Re: [PORTS] FATAL: role "postgres" does not exist"
Reply: Tom Lane: "Re: [PORTS] FATAL: role "postgres" does not exist"
Maybe reply: Bob Middaugh: "Re: [PORTS] FATAL: role "postgres" does not exist"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Mon Oct 08 2007 - 17:50:03 EDT