Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

 

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux