How to disable postgress?
I keep getting an error in n8n when trying to connect a new xata database that says "Error in sub-node ‘Xata‘
this endpoint works only with non postgres enabled branches" when I connected via api and I used the HTTP end point URL not the PostgresSQL Url and there are no other settings in my database for enabling or disbling postgres, nor are there any options to enable or disable postgress when I create the database either. The only branch available to me is "main" so I don't understand why I am getting this postgres enabled error
3 Replies
Hi there!
We've had a look into this issue, and we believe that it's happening here. With this in mind, can you let us know if you're using messages, chat history, or something of that nature? Anything that might make use of Xata Chat Memory.
If that is the case, a potential workaround is to try pre-create the table with the necessary columns before using it with the integration.
Alternatively, you could try using a Langchain/N8N Postgres integration. Langchain has one, though I can't confirm that it's exposed to N8N.
GitHub
langchainjs/libs/langchain-community/src/stores/message/xata.ts at ...
🦜🔗 Build context-aware reasoning applications 🦜🔗. Contribute to langchain-ai/langchainjs development by creating an account on GitHub.
yes its using chat memory as its for an sms chatbot with open ai
Im new xata, I only know as much as connecting http endpoint and api to n8n so it works out of the box. I don't understand anything you've said here. It was working fine before on xata and now suddenly just doesn't
Apologies for the confusion. Essentially the n8n integration was not created or maintained by Xata. It's not been updated in a while and it uses an old API to create tables and columns which is no longer supported.
The two potential workarounds we can see are to try to create the table in advance or to try using the Langchain integration instead at https://js.langchain.com/docs/integrations/memory/postgres/
I'll see if I can get a bit more detail for you to help as best I can.
Postgres Chat Memory | 🦜️🔗 Langchain
For longer-term persistence across chat sessions, you can swap out the default in-memory chatHistory for a Postgres Database.