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