Thread: Postgres, tablespaces, and quotas

Postgres, tablespaces, and quotas

From
John Browne
Date:
I was just curious about what would happen given the following scenario:

- Unix user has their own tablespace (and corresponding database)
stored in /home/someuser/mydata

- Quotas are enabled on /home

- User reaches their quota, effectively causing only this tablespace
to run out of disk space.


How would postgres handle this scenario?

Re: Postgres, tablespaces, and quotas

From
Tom Lane
Date:
John Browne <jkbrowne@gmail.com> writes:
> I was just curious about what would happen given the following scenario:

> - Unix user has their own tablespace (and corresponding database)
> stored in /home/someuser/mydata
> - Quotas are enabled on /home
> - User reaches their quota, effectively causing only this tablespace
> to run out of disk space.

> How would postgres handle this scenario?

It's not tested very often but I think it should work all right ---
insertions and updates into that tablespace might fail but otherwise
no problem.

What you want to watch out for is running out of space for pg_xlog
or pg_clog.  Either one will cause a database panic shutdown.  No
data loss, but no service either till you free up some space :-(

            regards, tom lane