a month ago
Hi,
Need help urgently.
My workflows are in Postgres database. I can still see in but not appearing on my project workspace.
What can I do so that I can see all my workflows.
4 Replies
a month ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open Railway • about 1 month ago
a month ago
Hey whatsup thantzw
What workflow tool are you using (n8n, Temporal, etc.)? Also, when you say you can "still see in" the Postgres database, are you querying the DB directly and seeing the data there?
Assuming it's n8n related: check if your N8N_ENCRYPTION_KEY environment variable is still set to its original value Also verify your DATABASE_URL is pointing to the correct Postgres instance (check the hostname/port match). You can confirm by running SELECT id, name FROM workflow_entity; directly against your DB to see what's there.
a month ago
If you mean services are not visible in the project canvas, and you can only see the postgres database. Just hold and drag the database service away, and you will see the rest of your services beneath it.
gui-wf
Hey whatsup thantzwWhat workflow tool are you using (n8n, Temporal, etc.)? Also, when you say you can "still see in" the Postgres database, are you querying the DB directly and seeing the data there?Assuming it's n8n related: check if your N8N_ENCRYPTION_KEY environment variable is still set to its original value Also verify your DATABASE_URL is pointing to the correct Postgres instance (check the hostname/port match). You can confirm by running SELECT id, name FROM workflow_entity; directly against your DB to see what's there.
a month ago
hi.. feeling messed up. haha..
so I used DBeaver, SELECT id, name FROM workflow_entity; this showed me all my workflows. But these workflows are not listed in my workspace. I check the encryption key and they are the same.
darseen
If you mean services are not visible in the project canvas, and you can only see the postgres database. Just hold and drag the database service away, and you will see the rest of your services beneath it.
a month ago
I can see my workflows when I clicked on the postgres -> database -> workflow entity. but these are not appearing on my workspace.