Re: FileSize limit not handled.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Fr d ric SURLEAU" <frederic(dot)surleau(at)atosorigin(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: FileSize limit not handled.
Date: 2003-03-24 16:46:46
Message-ID: 16969.1048524406@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Frdric SURLEAU" <frederic(dot)surleau(at)atosorigin(dot)com> writes:
> On this system, the file size is limited using ulimit.=0D
> =0D
> When the limit is reached for a database file, Postgres does THIS :=0D
> =0D
> LOG: server process (pid 4820) was terminated by signal 25=0D
> LOG: terminating any other active server processes=0D

It would probably work to just ignore SIGXFSZ on systems that have it.
That would change the behavior into an error return from write(), which
we already know what to do with.

Note however that running PG under a filesize ulimit is a rather foolish
thing to do. Running out of space for an ordinary table is one thing,
but running out of space for pg_xlog or pg_clog will induce a system
panic not materially different from the above.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2003-03-24 18:21:55 Bug #917: SERVICE DENIAL ON XP
Previous Message William.Jiang 2003-03-24 15:05:11 POSTMASTER crashed when I execute a function