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
Uh oh!
There was an error while loading. Please reload this page.
-
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