PostgreSQL: No space left on device

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