Replies: 1 comment
-
Again the API comes to the rescue to workaround the issue because the export project isn't working very well. I have 2 instances of Semaphore running. One is the original using Boltdb and the 2nd using Postgres. I've written a Python program that gets the data from the first instance and sends it to the second instance. Now everything is imported into Postgres. Noice. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Has anyone been able to migrate from BoltDB to Postgres? I don't see any tools that can do this.
I created a new instance of Semaphore that was configured to use Postgres. All the tables were created OK.
I exported my project using the 'Backup (json)' button and tried to restore it in the new instance but when I go to 'Task Templates' in the new instance it hangs, and I get errors in the log:
time="2024-07-12T13:19:42Z" level=error msg="pq: unnamed prepared statement does not exist"
time="2024-07-12T13:19:47Z" level=error msg="pq: bind message has 4 result formats but query has 9 columns"
time="2024-07-12T13:19:47Z" level=error msg="pq: bind message has 9 result formats but query has 4 columns"
followed by a debug stack.
Anyone else been successful and give me some advice? Thank you
Beta Was this translation helpful? Give feedback.
All reactions