From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
"Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc:
Andrew Dunstan <andrew(at)dunslane(dot)net>, Jeff Davis <pgsql(at)j-davis(dot)com>,
"Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>, pgsql-hackers(at)postgresql(dot)org,
Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Subject:
Re: SOC & user quotas
Date:
2007-03-01 22:28:18
Message-ID:
17623.1172788098@sss.pgh.pa.us (view raw or flat )
Thread:
2007-02-28 16:26:53 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-02-28 16:46:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-28 17:14:13 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-02-28 17:31:20 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-02-28 16:56:58 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 17:19:17 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-02-28 17:28:55 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 17:38:47 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-02-28 17:48:12 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-03-01 08:53:26 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-02-28 17:56:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-28 17:58:52 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 18:39:36 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2007-02-28 18:50:09 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 20:57:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-28 21:23:58 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
2007-02-28 21:35:25 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-02-28 22:29:52 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 23:01:22 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-03-01 20:58:55 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2007-02-28 22:26:48 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2007-02-28 19:14:34 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
2007-02-28 22:48:38 from Joachim Wieland <joe(at)mcknight(dot)de>
2007-02-28 23:02:27 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-03-01 03:39:33 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2007-03-01 03:42:15 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-03-01 21:21:34 from Jeff Davis <pgsql(at)j-davis(dot)com>
2007-03-01 21:45:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-01 22:06:34 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-03-01 22:13:20 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-03-01 22:28:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-01 22:35:09 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-03-02 18:58:21 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2007-03-01 22:37:04 from Jeff Davis <pgsql(at)j-davis(dot)com>
2007-03-01 22:53:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-01 23:56:56 from Jeff Davis <pgsql(at)j-davis(dot)com>
2007-03-02 00:31:44 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-03-02 01:08:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-02 01:22:09 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-03-02 01:26:41 from Jeff Davis <pgsql(at)j-davis(dot)com>
Lists:
pgsql-hackers
"Joshua D. Drake" <jd(at)commandprompt(dot)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 :-(
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Andrew DunstanDate: 2007-03-01 22:35:09
Subject : Re: SOC & user quotas
Previous :From : Joshua D. DrakeDate : 2007-03-01 22:13:20
Subject : Re: SOC & user quotas