ALTER TABLE ADD CONSTRAINT fails with "No space left on device" error
Query: ALTER TABLE "<table>" ADD CONSTRAINT "<key>" PRIMARY KEY (<column_1>, <column_2>);
Error: PANIC: could not write to file "pg_wal/xlogtemp.524": No space left on device (SQLSTATE 53100)
I am trying to migrate my database from another PostgreSQL provider to Neon using a documented method (pg_dump + pg_restore), but I got stuck on this issue. The first time this error occurred was during pg_restore. After pg_restore finished (with only this error), I tried to run the following query again by connecting to the database via psql (unfortunately with the same error) and then in Neon SQL Editor, but with the same error.
I also tried different plans (Launch and Scale) without results.
I'd greatly appreciate any help to solve this issue!
4 Replies
stormy-gold•2y ago
@aleveha since you’re a paying customer, you should open a support case: support@neon.tech
exotic-emeraldOP•2y ago
@ShinyPokemon, I did it! However, the support team is available only Monday to Friday. Since today is Sunday, I decided to search and ask here too. Maybe someone has already experienced the same issue and can help me solve it.
stormy-gold•2y ago
Fair! Can you share the project id with me?
exotic-emeraldOP•2y ago
Sent in DM! Thanks!