Symphony setup wizard cannot create a PostgreSQL database

Issue

The Symphony setup wizard cannot create a Symphony database on an existing PostgreSQL database server.

Cause

The Symphony setup wizard must use a user account with superuser permission to create the Symphony database.

Resolution

Configure the Symphony setup wizard to use a user account that has superuser permission on the PostgreSQL database server.

Note: Once the Symphony database is created, you may reduce the permissions of the user account used to create the database. The following are the minimum PostgreSQL permissions required to run the Symphony Server:

• LOGIN
• NOSUPERUSER
• INHERIT
• NOCREATEDB
• NOCREATEROLE
• NOREPLICATION
• GRANT ALL ON SCHEMA "public" TO "testDBUser";
• GRANT ALL ON ALL TABLES IN SCHEMA "public" TO "testDBUser";
• GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public to "testDBUser";