Re: SOC & user quotas

On Thursday 01 March 2007 17:35, Andrew Dunstan wrote:
> Tom Lane wrote:
> > "Joshua D. Drake" <jd@commandprompt.com> writes:
> >> Andrew Dunstan wrote:
> >>> Hitting a file system quota limit is likely to bring you down pretty
> >>> hard, isn't it?
> >>
> >> Yes, and likely corrupt the database.
> >
> > As long as you don't keep WAL on the restricted filesystem, it won't
> > stop or corrupt your database.  Whether you can get anything much done
> > is another story :-(
>
> Yeah. Including recovery. Maybe we could do something that would work in
> cooperation with FS quotas - I have no idea what though.
>

I've actually run postgresql systems out of disk space both on data partitions 
and wal partitions and never suffered corruption.  Certainly I don't 
recommend the practice, but pg can be amazingly resilient at times. 

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL