If you see error: duplicate key value violates unique constraint “pg_type_typname_nsp_index” then you most probably tried to restart “create table” command and previous process is still running. This constraint is an unique index on table...
Error “no space left on device” is probably the biggest nightmare of every PostgreSQL admin. Here you can see how it looks like in pg main log. If this happens it usually means your database is screwed in some way because pg_xlog (pg_wal in version 10+) is...
If you see error “write failed” during query run on Linux machine then it most probably means this: PostgreSQL is making query which demands big sorting, hashing etc. But there is not enough free memory so database has to write temporary files on disk But...
This is not exactly “incredibly clever nerd stuff” but it works and you are most welcome to suggest improvements. This “fat beauty” collects all information about error using GET STACKED DIAGNOSTICS command. Then checks error details and create...
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More Privacy & Cookies Policy