Failed to start up after configuring Postgresql

[dujas]

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.

[Benjamin]

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