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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.