Re: quota's ? - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: quota's ?
Date
Msg-id 3ADB740C.2F0AFF9@selectacast.net
Whole thread Raw
In response to Re: quota's ?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: 7.0.3 ==> 7.1
Next
From: The Hermit Hacker
Date:
Subject: Re: Re: erServer beta