| From: | "Roopeshakumar Narayansa Shalgar (rshalgar)" <rshalgar(at)cisco(dot)com> |
|---|---|
| To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | PANIC: could not create file "pg_xlog/xlogtemp.7884": No space left on device |
| Date: | 2014-09-25 10:44:42 |
| Message-ID: | F9567754259D974D88F5F5337C9D219620BCC36C@xmb-aln-x11.cisco.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2014-09-25 12:10:26 | Re: Synchronous replication + pgPool: not all transactions immediately visible on standby |
| Previous Message | Pavel Stehule | 2014-09-25 10:28:55 | Re: How to clone CURRENT_DATE to SYSDATE ? |