Connecting jira to postgresql database with custom schema

[vishwas]

Hello All,

Can we connect jira software to postgresql database other than public schema ?

If so how the schema should be configured for privileges so that it connects to jira application.

Thanks & Regards,

Vishwas

[culyzhao · Accepted solution]

I also have this problem, and did some study on it, there are serveral ways to solve it.

1. Use @Tinker Fadoua metioned method, set search_path.

2. Modify  dbconfig.xml, add currentSchema paremeter to jdbc url:

<url>jdbc:postgresql://ip:5432/yourdb?currentSchema=jira</url>

3. Create the schema same as your jira db login user.

In postgresql, show search_path command will show the search_path settings, default result is "$user", public. It means default schema is same as current logon username. 

[Tinker Fadoua · Accepted solution]

@vishwas 

Yes you can. In fact I had issues 2 days ago configuring the Postgres to Jira because I was using the public schema.

ALTER DATABASE <database name> SET search_path TO <your schema>,public;

Run the command above after adding your schema.

Best,

Fadoua

[vishwas]

@Tinker Fadoua 

Thanks for the help

It helped me after setting search_path

Thanks & Regards,

Vishwas

[Tinker Fadoua]

Thank you for accepting my answer @vishwas !