Re: quota's ?

Sander Steffann wrote:
>
> Hi,
>
> > On Sat, Apr 07, 2001 at 01:46:48PM -0400, Doug McNaught wrote:
> > > Peter Eisentraut <peter_e(at)gmx(dot)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(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com