cmck
Requests that go on forever and no response
Out of interest, does the same happen if you connect using pgAdmin and run the same query? Looking at our logs from last night I can see some connections that stayed open for a long time before they were closed. To clarify, do the queries ever execute or is it just when you try to run them for the first time that they hang?
Thanks for bearing with us. If you can share a timestamp in UTC with a date of when you last cancelled a long running query, that would be great.
16 replies
Working with Postgis
Hi thanks for bearing with me. So, Postgis was originally shipped with our shared cluster but we had to disable it due to several issues that arose. It's currently only available on dedicated clusters. If you need this extension for your application then I would not recommend using Xata for the time being.
Apologies for any misunderstanding, our documentation needs to be updated to reflect the above.
Please let me know if there's anything else I can help you with.
9 replies
Filter not working.
No problem, can you please share your workspace ID? I'm afraid I can't find the workspace for the support view without it. You may also need to disable support access and re-enable it to re-send the invite. Apologies for the delay.
6 replies
How much replicate can create in PRO plan
Hi, sorry for the delay getting back to you, I was out of office for the past week. Apologies, but I'm not sure I understand your query.
How do you plan to replicate the data? Are you talking about using
pgstream
to replicate between databases in Xata? Do you mean the "replicas" referred to in the dedicated cluster section of our pricing page? https://xata.io/pricing
Please bear in mind that there is no specific replication mechanism built within Xata (other than the in-cluster read replicas, and the replication to Search for the Pro users).4 replies
I can't really connect to the DB does
Hi there, I see you've reached out to [email protected] so I will reply on the ticket shortly. Thanks for bearing with me.
1 replies
no schema has been selected to create in error
Hi there, thanks for your patience. Does the error persist when you don't set the
search_path
? Because Xata stores data on a shared cluster (with other users), it sets a specific search_path
upon connection to ensure you connect to your schema.2 replies
PATCH record not working but GET is?
Hi there, I'll take a look and see what the issue might be. Could you please share your workspace slug? You can do so privately by emailing [email protected] . Once I have the workspace slug I'll be able to toubleshoot further.
5 replies