Re: quota's ?

Sander Steffann wrote:
>
> Hi,
>
> > On Sat, Apr 07, 2001 at 01:46:48PM -0400, Doug McNaught wrote:
> > > Peter Eisentraut <peter_e@gmx.net> writes:
> > >
> > > > Doug McNaught writes:
> > > >
> > > > > Doing this would almost certainly result in a corrupted database
> once
> > > > > you ran up against the limit.
> > > >
> > > > I think you can give PostgreSQL a little more credit than that.  ;-)
> > >
> > > I'm very glad to hear it.  A lot of applications don't cope with
> > > filesystem-full/quota-exceeded very well at all.  ;)
> >
> > I've not been following postgres-hackers as closely as I should, but
> > as of the first betas of 7.1, it would corrupt your database horribly
> > if you ran out of space.
> >
> > I think this has been fixed, but you might wanna check with hackers or
> > release nots.
>
> Just to make sure: what DOES happen if PostgreSQL runs out of space?
>
I've had it happen to me recently.  I saw an error message in the
postgres log about the filesystem being full.  I got rid of some file
and postgres just went on working, I didn't have to restart it or
anything.  That was 7.0.3

--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com