Re: [GENERAL] No space left on device

2017-02-19 Thread Melvin Davidson
gt; - Original Message - >> From: "Sachin Srivastava" <ssr.teleat...@gmail.com> >> To: "Alvaro Aguayo Garcia-Rada" <aagu...@opensysperu.com> >> Cc: "pgsql-general@postgresql.org >> PG-General Mailing List" < >> pgsql-gener

Re: [GENERAL] No space left on device

2017-02-18 Thread Sachin Srivastava
Original Message - > From: "Sachin Srivastava" <ssr.teleat...@gmail.com> > To: "Alvaro Aguayo Garcia-Rada" <aagu...@opensysperu.com> > Cc: "pgsql-general@postgresql.org >> PG-General Mailing List" < > pgsql-general@postgresql.org> &g

Re: [GENERAL] No space left on device

2017-02-18 Thread Alvaro Aguayo Garcia-Rada
(+51) 954183248 Website: www.ocs.pe - Original Message - From: "Sachin Srivastava" < ssr.teleat...@gmail.com > To: " pgsql-general@postgresql.org >> PG-General Mailing List" < pgsql-general@postgresql.org > Sent: Sunday, 19 February, 2017 12:5

Re: [GENERAL] No space left on device

2017-02-18 Thread Sachin Srivastava
54183248 >> Website: www.ocs.pe >> >> - Original Message - >> From: "Sachin Srivastava" <ssr.teleat...@gmail.com> >> To: "pgsql-general@postgresql.org >> PG-General Mailing List" < >> pgsql-general@postgresql.org> >>

Re: [GENERAL] No space left on device

2017-02-18 Thread Sachin Srivastava
: "pgsql-general@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 du

Re: [GENERAL] No space left on device

2017-02-18 Thread Alvaro Aguayo Garcia-Rada
t: 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 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

[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

[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 this in

[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). Sheesh.

[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

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

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

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 seriously doubt

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