Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Failed to start up after configuring Postgresql

Hi guys,

I am trying to switch the database from sql server to postgresql 14.1 by following link:
https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html#Switchingdatabases-differenttype

When I finsihed the creation and configuration of new database in Postgresql, then click next in setup page, it posted "gateway timeout error" and from log files I noticed:

"org.postgresql.util.PSQLException: ERROR: relation "public.A0_8752F1_DATA_PIPELINE_JOB" does not exist".

Well, I checked the solution in https://jira.atlassian.com/browse/JRASERVER-64886 and added a new schema, then alter the search_path to it from default "$user", but issue kept still.

May I have some suggestions from you guys?

Thanks.

1 answer

0 votes
Benjamin Community Leader Nov 30, 2021

HI @dujas ,

 

Do you get a different error with a different schema/table missing after making the change?

 

If you do, I would try to fix each one till all is repaired.

 

-Ben

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

JSM Jira Automation: How to Send SLA Breached Notifications

Hi Everyone, In   this tutorial,  we will show you how you can monitor an SLA, and send notifications before or after the SLA has been breached.   SLA Threshold Trigger The SLA t...

688 views 5 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you