Running out of Disk Space

From: John Taylor <postgres(at)jtresponse(dot)co(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Running out of Disk Space
Date: 2002-04-05 18:24:14
Message-ID: 02040519241400.06859@splash.hq.jtresponse.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


I'm running PostgreSQL 7.1.

A few times now I have run out of disk space on the drive containing the postgresql data.
In all cases, this has corrupted the database, the postmaster has died, and refuses to start again
unless I rebuild from scratch.

As my app is under development at the moment, this isn't a big disaster, but I'm worrying
about what will happen when I go live.

The situation isn't helped by the postgres home directory being on /var, which could easily run out
of space for a number of reasons. (or is putting it in /var a Mandrake thing ? )

Obviously the solution is to put postgre on a disk with enough space, but I can see the App sitting
on the web server for a number of years until everyone forgets to check disk space - then BANG!

My question is:
Is it normal for postgres to get corrupted due to lack of disk space ?
Surely it should be able to handle this.

The problems have all occurred while processing a large transaction - could that be the cause ?

Thanks
JohnT

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-04-05 19:25:42 Re: identity columns ?
Previous Message Lloyd Vancil 2002-04-05 17:17:40 Re: OID