Error while instaling jira with postgres 9.6

[Juan Bertolotti]

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}]

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 <Database Name> TO <Role Name>

You can refer this page for setting up JIRA with postgresql. 

Thanks,
Amith Mathur

[Juan Bertolotti]

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

Ive already did that:

[Amith Mathur {Appfire}]

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