-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Tue, 4 Nov 2014 17:00:54 +0000 (UTC), Alejandro Carrillo
(fasterzip@yahoo.es) wrote about "Re: [GENERAL] Tablespace limit
feature" (in
<1781968257.697829.1415120454794.JavaMail.yahoo@jws11113.mail.ir2.yahoo.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.w.noon@googlemail.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-----