PANIC: could not create file "pg_xlog/xlogtemp.7884": No space left on device - Mailing list pgsql-general

Hi,

I am using version 9.3.1 and see the “no space device error” even though there is enough space (99% free) on my disk.

Error: PANIC:  could not create file "pg_xlog/xlogtemp.7884": No space left on device

I want to know whether this is a bug and if yes whether fix or workaround is available.

I am using the default configuration mentioned in the postgresql.conf file.

bash-3.2# du -h

4.0K    ./pg_stat

6.2M    ./base/12026

198M    ./base/16384

6.3M    ./base/12031

6.3M    ./base/1

216M    ./base

24K     ./pg_stat_tmp

4.0K    ./pg_snapshots

4.0K    ./pg_serial

12K     ./pg_multixact/offsets

12K     ./pg_multixact/members

28K     ./pg_multixact

448K    ./global

4.0K    ./pg_xlog/archive_status

129M    ./pg_xlog

4.0K    ./pg_tblspc

12K     ./pg_notify

4.0K    ./pg_twophase

128K    ./pg_clog

4.0K    ./pg_subtrans