Grokbase › Groups › PostgreSQL › pgsql-ports › August 2007
FAQ
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)


Any suggestions?

Thanks,
Bob

Search Discussions

  • Peter Eisentraut at Aug 16, 2007 at 4:28 pm ⇧

    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.
  • Tom Lane at Aug 16, 2007 at 4:29 pm ⇧

    Bob Middaugh writes:
    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.
    FreeBSD is being a bit out of step here --- the default superuser name
    is "postgres" in most distros. If you can't persuade the OpenNMS
    installer to use a nonstandard superuser name, it's no big deal ---
    just create a second superuser role named "postgres". See the CREATE
    ROLE command, or use the "createuser" script.

    regards, tom lane
  • Bob Middaugh at Aug 16, 2007 at 6:43 pm ⇧

    -------------- Original message ----------------------
    From: Tom Lane <[email protected]>
    [email protected] (Bob Middaugh) writes:
    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.

    FreeBSD is being a bit out of step here --- the default superuser name
    is "postgres" in most distros. If you can't persuade the OpenNMS
    installer to use a nonstandard superuser name, it's no big deal ---
    just create a second superuser role named "postgres". See the CREATE
    ROLE command, or use the "createuser" script.
    Thank you both. I su'd to FreeBSD's pgsql user and did createuser which allowed me to add postgres and the OpenNMS script that sets up the DB ran successfully.

    You're right Tom, other OS's I've seen referenced elsewhere in regards to postgresql seem to have postgres as the initial superuser. Why the FreeBSD ports maintainer for postgresql chooses pgsql...I dunno.

    There is no FreeBSD package (binary), or port, for OpenNMS like there are for a few linux distro's. Hopefully, I'm good to go now, thanks to you guys. If I have any more questions, I'll direct them to your novice mailing list. I started with ports because I figured this was a FreeBSD 'centric ports issue.

    Thanks for your help.

    Bob

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedAug 16, '07 at 4:09p
activeAug 16, '07 at 6:43p
posts4
users3
websitepostgresql.org
irc#postgresql

3 users in discussion

Bob Middaugh: 2 posts Peter Eisentraut: 1 post Tom Lane: 1 post

Content

People

Support

Translate

site design / logo © 2023 Grokbase