From: Dev <dev_hyd2001@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Best way to limit database sizes
Date: Thu, 3 Jul 2008 09:07:23 -0700 (PDT)
Message-ID: <619537.42270.qm@web53708.mail.re2.yahoo.com> (raw)
Hi,
I have a single Postgres server which will be hosting multiple databases belonging to different users. What would be the recommendation to limit the size of each of the databases?
I've considered creating a tablespace in a directory owned by the user , so I can use Linux quotas to prevent higher disk usage , but this turned out be a bad thought, as all the files are anyway owned by the postgres user and so disk quotas won't have any effect.
Now I'm contemplating having a cron job which checks the size of each tablespace belonging to a user and somehow informing the admin about db's getting over the threshold size.
Is there anyone who has tried a better way to limit the db sizes ?
cheers
/Dev
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dev_hyd2001@yahoo.com
Subject: Re: Best way to limit database sizes
In-Reply-To: <619537.42270.qm@web53708.mail.re2.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox