Xata

This is Xata's community Discord server, where we discuss all things Xata: projects, features, dreams!

Join

Xata

This is Xata's community Discord server, where we discuss all things Xata: projects, features, dreams!

Join

help

general

Raveen

11/18/2025

Unable to use Xata lite, not able to login and db requests failing

I'm not able to login to app.xata.io and all the db requests from my app are failing.

Michael Schaufelberger

11/6/2025

Search & Aggregations not working anymore after moving branch to dedicated cluster.

Hi 👋 We are experiencing the problem after moving to our cluster. The second query is giving back totalCount: 0, meaning it's not working anymore. ...

xSupeFly

10/13/2025

pg_dump running out of memory

Hello, I'm having problem exporting whole database of around 270mb using pg_dump command. command used: pg_dump --no-acl --no-owner --no-table-access-method --schema-only --format=tar --schema=public used without --schema-only same error...

pranavmappoli

10/8/2025

[to_tsvector] is unknown or not allowed

how to fix this ?

Ebat

10/6/2025

"Getting Error: Invariant failed: no organizations found error while xata init"

Iam migrating from supabase to xata when i do xata init step, it shouw the error "Getting Error: Invariant failed: no organizations found "...

viocha

9/14/2025

Bug: API traffic routed to US despite region setting

Hello Team, I've noticed an issue with API request routing. Even though I have set my database's region to ap-southeast-2, it appears the API requests are still being handled by a server in the United States. My database URL is:...

zero51

9/3/2025

Not enough disk space

Hi. We're trying to replicate a Neon table to Xata. The entire database in Neon is ~160GB, and we're just replicating one table. We have a xata.large instance, which reports a storage limit of 250GB on the Overview. Xata Metrics report a disk usage of 55GB, but the DB is no longer accessible and has a status of "Not enough disk space". Two questions: (1) why is 55GB breaching the 250GB storage limit, and (2) why is there a storage limit at all?...

Kaligraphy

9/1/2025

Unable to create new branch

Hello, When I try to migrate the schema from my dev branch to my main branch, I get this error: ```...

alihammad

7/20/2025

ask ai

Hi, I have a bug with my code, when I add sessionId to the options, I receive error (invalid key [rules] in request). It works when I remove rules and searchType ```js...

Sebastien

7/16/2025

Support for Xata early access?

I'm having some issues with extensions for Xata on early access, I'm unable to load postgis extension. SELECT * FROM pg_available_extensions; returns 47 results but postgis is not in there....

Westleee

7/14/2025

Trouble loading data in Xata Lite UI

Hi, I'm trying Xata Lite for a upcoming project. The UI doesn't render if the table have no primary key. I'm creating tables in db through direct connection. Is Xata planning to support this view in upcoming updates?

Whazzer

7/3/2025

Do you block servers from connecting?

I'm having a problem where the scripts located in one of my servers won't connect to Xata, but all other scripts in other servers do. I'm getting this error on the log: PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: could not translate host name "us-east-1.sql.xata.sh" to address: Name or service not known in /home/whazzer/public_html/vecino-seguro/servicios/sesion.php on line 13...

Kaligraphy

7/3/2025

Migrating data from A DB in one workspace to another DB in another workspace breaks my app

My workplace contracted third parties to help quickly build a CMS because we have so much on our plate. We used Xata, and can’t invite them to our main workspace because data privacy reasons. Now the project from 3rd party has been delivered, it works on their workspace -> database, but we want to have this on a db in our main workspace. I tried xata dump -f schema.json and xata init —schema.json, but got error about incorrect format. Since both DBs are native PG DBs, i ran pg_dump and pg_restore, which worked with some errors To use the database from our main workspace, should be straightforward, i removed old Xata files, and ran xata init and later xata pull to set up the project with the intended db. This worked, but breaks so may others things, id and xata_id no longer being “aliased”...

6/30/2025

Xata with commercial pg extensions.

Hi, I'm JP from Agenta (https://agenta.ai) and we're interested in postgres at scale, alongside other commercial extensions like the once from TigerData (formerly Timescale). How can we benefit from the benefit of both Xata and TigerData while not breaching TigerData's licensing model ?

Michael Schaufelberger

6/30/2025

Trouble with branch copy

Hi 👋 We are having trouble copying a branch on Xata Lite. A certain migration is not run Workspace ID:...

Maaz

6/10/2025

Do dedicated clusters scale to zero when DB is idle?

We are using Xata for our app and I've just purchased the Pro plan before going live as the shared cluster on free tier keep throwing "out of memory" error every once in a while despite very minimal use. When provisioning a cluster, I see the pricing calculator predict a monthly cost of $53.29 for 1 x db.t4g.medium. This is true if my instance runs 24/7 for the whole month. However, since Xata is serverless, my understanding is that the instance will shut down once idle for a certain period of time, and thus this $53.29 would not be billed if there are significant periods of idle time throughout the month. Just wanted to know if the above assumption is correct or $53.29 is the fixed amount you'll have to pay per month anyways for 1 x db.t4g.medium?...

ghqpio

6/6/2025

Hey, getting error while trying to access a table.

{id: "b93bbb94-3836-9e55-8d7d-f9608f77d239", message: "json: unsupported value: NaN"} Please have a look....

DigitalMischief

5/18/2025

Are there any elegant solutions to handling external connections if your DB is not Postgres enabled?

Hey everyone, love Xata - regrettably didn't realize I had to opt in for the native Postgresql wire initially when creating a database so my long lived prod instance does not use the native wire and thus I am finding that replicating any of the data outside of Xata is a bit of a chore as postgres event handling is not an option for me. Does anyone have any good ideas, resources or a direction to point me to find a way to thoughtfully expose my data to external platforms without polling?

Tim L

5/16/2025

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...

Patie

5/12/2025

General questions for multitenant SaaS

Hi, I have multiple questions: 1. What is structure of Xata - workspace -> clusters -> databases? 2. How many databases can be in one workspace/cluster?...

Gaming

Programming

Xata

This is Xata's community Discord server, where we discuss all things Xata: projects, features, dreams!

Xata

This is Xata's community Discord server, where we discuss all things Xata: projects, features, dreams!