FATAL: role "postgres" does not exist
От | bob.middaugh@comcast.net (Bob Middaugh) |
---|---|
Тема | FATAL: role "postgres" does not exist |
Дата | |
Msg-id | 081620071609.24745.46C476B3000B68DF000060A9221352857308099A0E0B0B0703D20D010D@comcast.net обсуждение исходный текст |
Ответы |
Re: FATAL: role "postgres" does not exist
Re: FATAL: role "postgres" does not exist |
Список | pgsql-ports |
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
В списке pgsql-ports по дате отправления: