Re: [GENERAL] No space left on device

2017-02-19 Thread Melvin Davidson
gt;> From: "Sachin Srivastava" >> To: "Alvaro Aguayo Garcia-Rada" >> Cc: "pgsql-general@postgresql.org >> PG-General Mailing List" < >> pgsql-general@postgresql.org> >> Sent: Sunday, 19 February, 2017 1:03:09 AM >> Sub

Re: [GENERAL] No space left on device

2017-02-18 Thread Sachin Srivastava
Message - > From: "Sachin Srivastava" > To: "Alvaro Aguayo Garcia-Rada" > Cc: "pgsql-general@postgresql.org >> PG-General Mailing List" < > pgsql-general@postgresql.org> > Sent: Sunday, 19 February, 2017 1:03:09 AM > Subject: Re: [GENERA

Re: [GENERAL] No space left on device

2017-02-18 Thread Alvaro Aguayo Garcia-Rada
www.ocs.pe - Original Message - From: "Sachin Srivastava" To: "Alvaro Aguayo Garcia-Rada" Cc: "pgsql-general@postgresql.org >> PG-General Mailing List" Sent: Sunday, 19 February, 2017 1:03:09 AM Subject: Re: [GENERAL] No space left on device With correct

Re: [GENERAL] No space left on device

2017-02-18 Thread Sachin Srivastava
.ocs.pe >> >> ----- Original Message - >> From: "Sachin Srivastava" >> To: "pgsql-general@postgresql.org >> PG-General Mailing List" < >> pgsql-general@postgresql.org> >> Sent: Sunday, 19 February, 2017 12:51:49 AM &

Re: [GENERAL] No space left on device

2017-02-18 Thread Sachin Srivastava
al@postgresql.org >> PG-General Mailing List" < > pgsql-general@postgresql.org> > Sent: Sunday, 19 February, 2017 12:51:49 AM > Subject: [GENERAL] No space left on device > > > > Dear Expert, > > > My PostgreSQL database got down due to no space left on my

Re: [GENERAL] No space left on device

2017-02-18 Thread Alvaro Aguayo Garcia-Rada
+51-1) 3377813 | RPM: #034252 / (+51) 995540103 | RPC: (+51) 954183248 Website: www.ocs.pe - Original Message - From: "Sachin Srivastava" To: "pgsql-general@postgresql.org >> PG-General Mailing List" Sent: Sunday, 19 February, 2017 12:51:49 AM Subject: [GENERAL]

[GENERAL] No space left on device

2017-02-18 Thread Sachin Srivastava
Dear Expert, My PostgreSQL database got down due to no space left on my mount point /dev/vdb1 where my data directory are available, please suggest what's the best solution to resolve this issue. I am also not able to start my database again due to no space available. And right now, we don't have

[GENERAL] No space left on device log message storm

2011-07-31 Thread Bryan Henderson
>When the filesystem containing my database fills up, the server repeats >the following log message about as fast as it can log: > > Jun 29 23:00:55 src@giraffe postgres: LOG: could not write temporary > statistics file "pg_stat_tmp/pgstat.tmp": No space left on device In case anyone finds thi

[GENERAL] No space left on device log message storm

2011-07-05 Thread Bryan Henderson
When the filesystem containing my database fills up, the server repeats the following log message about as fast as it can log: Jun 29 23:00:55 src@giraffe postgres: LOG: could not write temporary statistics file "pg_stat_tmp/pgstat.tmp": No space left on device Is this an infinite loop or the

Re: [GENERAL] no space left on device

2004-01-10 Thread Bruno Wolff III
On Sat, Jan 10, 2004 at 00:38:43 +, "Nigel J. Andrews" <[EMAIL PROTECTED]> wrote: > > On Sat, 10 Jan 2004, Nigel J. Andrews wrote: > > And a common culprit is whatever is being used for usenet caching/serving...or > > ordinary mail which is just accumulating in /var/mail (or whereever). > >

Re: [GENERAL] no space left on device

2004-01-09 Thread Nigel J. Andrews
On Sat, 10 Jan 2004, Nigel J. Andrews wrote: > And a common culprit is whatever is being used for usenet caching/serving...or > ordinary mail which is just accumulating in /var/mail (or whereever). Sheesh. Did I really put ordinary mailbox mail in the uses up inodes category? I should taken out a

Re: [GENERAL] no space left on device

2004-01-09 Thread Nigel J. Andrews
On Fri, 9 Jan 2004, scott.marlowe wrote: > On Fri, 9 Jan 2004, Aurangzeb M. Agha wrote: > > > Right! Thus my quandry. > > > > Re inodes, how can I check this? But why would this be? Is Postgres > > sucking up inodes just sitting there as a read-only DB? > > If you are out of inodes, I seriou

Re: [GENERAL] no space left on device

2004-01-09 Thread Mark Kirkwood
I would suspect some *other* service is using the 4G for transient storage every now and again, and it just so happens that Pg is getting tripped up. What else does this machine run ? regards Mark Nigel J. Andrews wrote: On Fri, 9 Jan 2004, Aurangzeb M. Agha wrote: Here's the output of

Re: [GENERAL] no space left on device

2004-01-09 Thread scott.marlowe
On Fri, 9 Jan 2004, Aurangzeb M. Agha wrote: > Right! Thus my quandry. > > Re inodes, how can I check this? But why would this be? Is Postgres > sucking up inodes just sitting there as a read-only DB? If you are out of inodes, I seriously doubt it is Postgresql's fault, as you seem to be run

[GENERAL] no space left on device

2004-01-09 Thread Aurangzeb M. Agha
I'm running Postgres 7.1.3, and just started having a problem where my dynamic site is going down (read-only DB, with no writes happening to the DB) regularly (every other day). I have no idea whay this is happening, and my search of the FAQ's and mail list don't bring up anything. i've attached