Re: Tablespace limit feature

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 4 Nov 2014 17:00:54 +0000 (UTC), Alejandro Carrillo
(fasterzip(at)yahoo(dot)es) wrote about "Re: [GENERAL] Tablespace limit
feature" (in
<1781968257(dot)697829(dot)1415120454794(dot)JavaMail(dot)yahoo(at)jws11113(dot)mail(dot)ir2(dot)yahoo(dot)com>):

> I need to limit the tablespace file because I need to control the
> hard disk space used in a tablespace. Anybody knows how to do this?
> Or if it this in the PostgreSQL roadmap?

The way I handle this is to allocate each tablespace its own logical
volume or partition and to mount it as /var/db/<tablespace>. This
causes the filesystem itself to limit the amount of disk space the
tablespace can use.
- --
Regards,

Dave [RLU #314465]
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
david(dot)w(dot)noon(at)googlemail(dot)com (David W Noon)
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEARECAAYFAlRZCzIACgkQogYgcI4W/5Q9PQCfXAnKwoRTOUmRZVJsjVn2ysZH
brgAnRudOLOUGSuIVmY7xiRqSZCWL6l/
=v2yc
-----END PGP SIGNATURE-----