Error while instaling jira with postgres 9.6

Question

Hi all, im getting the following while trying to install jira using postgres db

com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM jiradb.propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? (ERROR: relation "jiradb.propertyentry" does not exist
 Position: 68)

Amith Mathur {Appfire} · Answer

Hi @Juan Bertolotti,

Can you stop jira and verify that the privileges were granted successfully, connect to the database and run the \z command?

Once you verify the privileges, restart the JIRA.

If it still does not work, then please recreate a new database schema and follow the steps as mentioned in the referred link.

Thanks,
Amith Mathur

Juan Bertolotti · Answer

Hi @Amith Mathur {Appfire}, Thank you very much for taking the time to help me.

Ive already did that:

Amith Mathur {Appfire} · Answer

Hi @Juan Bertolotti Can you please verify that you have granted all the permissions for the postgresql user? Please ensure that the user has permissions to connect to the database, and to create and write to tables in the database. GRANT ALL PRIVILEGES ON DATABASE TO You can refer this page for setting up JIRA with postgresql. Thanks, Amith Mathur