[GENERAL] URGENT: Whole DB down (no space left on device)

2007-08-31 Thread Phoenix Kiula
I am getting this message when I start the DB: psql: FATAL: could not access status of transaction 0 DETAIL: Could not write to file pg_subtrans/01F8 at offset 221184: No space left on device. What is this about and how do I solve this? A df -h on my system shows this: FilesystemType

Re: [GENERAL] URGENT: Whole DB down (no space left on device)

2007-08-31 Thread Tommy Gildseth
Phoenix Kiula wrote: I am getting this message when I start the DB: psql: FATAL: could not access status of transaction 0 DETAIL: Could not write to file pg_subtrans/01F8 at offset 221184: No space left on device. What is this about and how do I solve this? A df -h on my system shows this:

Re: [GENERAL] URGENT: Whole DB down (no space left on device)

2007-08-31 Thread Bruce McAlister
Looks like you're out of disk space on: /dev/sda2 ext39.9G 9.5G 0 100% /var is this where your database resides? Phoenix Kiula wrote: I am getting this message when I start the DB: psql: FATAL: could not access status of transaction 0 DETAIL: Could not write to file

Re: [GENERAL] URGENT: Whole DB down (no space left on device)

2007-08-31 Thread Merlin Moncure
On 8/31/07, Phoenix Kiula [EMAIL PROTECTED] wrote: I am getting this message when I start the DB: psql: FATAL: could not access status of transaction 0 DETAIL: Could not write to file pg_subtrans/01F8 at offset 221184: No space left on device. What is this about and how do I solve this?

Re: [GENERAL] URGENT: Whole DB down (no space left on device)

2007-08-31 Thread Josh Tolley
On 8/31/07, Zoltan Boszormenyi [EMAIL PROTECTED] wrote: Phoenix Kiula írta: I am getting this message when I start the DB: psql: FATAL: could not access status of transaction 0 DETAIL: Could not write to file pg_subtrans/01F8 at offset 221184: No space left on device. What is

Re: [GENERAL] URGENT: Whole DB down (no space left on device)

2007-08-31 Thread Zoltan Boszormenyi
Phoenix Kiula írta: I am getting this message when I start the DB: psql: FATAL: could not access status of transaction 0 DETAIL: Could not write to file pg_subtrans/01F8 at offset 221184: No space left on device. What is this about and how do I solve this? A df -h on my system shows this:

Re: [GENERAL] URGENT: Whole DB down (no space left on device)

2007-08-31 Thread Phoenix Kiula
On 31/08/2007, Zoltan Boszormenyi [EMAIL PROTECTED] wrote: Phoenix Kiula írta: I am getting this message when I start the DB: psql: FATAL: could not access status of transaction 0 DETAIL: Could not write to file pg_subtrans/01F8 at offset 221184: No space left on device. What

Re: [GENERAL] URGENT: Whole DB down (no space left on device)

2007-08-31 Thread Phoenix Kiula
On 31/08/2007, Josh Tolley [EMAIL PROTECTED] wrote: On 8/31/07, Zoltan Boszormenyi [EMAIL PROTECTED] wrote: Phoenix Kiula írta: In addition to what others have already said, when things calm down you should consider implementing some sort of monitoring system that is configured to start

Re: [GENERAL] URGENT: Whole DB down (no space left on device)

2007-08-31 Thread Erik Jones
On Aug 31, 2007, at 8:35 AM, Phoenix Kiula wrote: Thanks everyone. Yes, /var was full because of the backups that're going there. Database is back working. It was my backup script. It is set to save a daily backup to the /var/ folder, which is not clever. I'll change it to be in the backup

Re: [GENERAL] URGENT: Whole DB down (no space left on device)

2007-08-31 Thread Jeff Davis
On Fri, 2007-08-31 at 22:34 +0800, Phoenix Kiula wrote: On 31/08/2007, Josh Tolley [EMAIL PROTECTED] wrote: On 8/31/07, Zoltan Boszormenyi [EMAIL PROTECTED] wrote: Phoenix Kiula írta: In addition to what others have already said, when things calm down you should consider implementing

Re: [GENERAL] URGENT: Whole DB down (no space left on device)

2007-08-31 Thread Anton Melser
On 31/08/2007, Jeff Davis [EMAIL PROTECTED] wrote: On Fri, 2007-08-31 at 22:34 +0800, Phoenix Kiula wrote: On 31/08/2007, Josh Tolley [EMAIL PROTECTED] wrote: On 8/31/07, Zoltan Boszormenyi [EMAIL PROTECTED] wrote: Phoenix Kiula írta: In addition to what others have already said,