Обсуждение: Postgres and disk space

Is it possible to make data files owned by a unix user other than
postgres?

It would be convenient for me because that would help to enforce quotas.

Are there other methods? Is it dangerous (aside from the dangers to that
user, obviously) to let them delete files in their data directory? Does
postgres handle out-of-disk errors in a reasonable way?

Regards,
    Jeff Davis

Jeff Davis wrote:
> Is it possible to make data files owned by a unix user other than
> postgres?
>
> It would be convenient for me because that would help to enforce quotas.

No, it isn't possible.  Once we have tablespaces, you could put
different databases on different file systems with different quotas, but
each file system quote would have to be for the postgres user.

>
> Are there other methods? Is it dangerous (aside from the dangers to that
> user, obviously) to let them delete files in their data directory? Does
> postgres handle out-of-disk errors in a reasonable way?

Yes, we handle out-of-disk space errors just fine, though 7.4.2 is the
recommended version for such cases because we have had more testing
there for that case.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073