From: | "Aaron Bono" <postgresql(at)aranya(dot)com> |
---|---|
To: | andy(dot)shellam(at)mailnetwork(dot)co(dot)uk |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Separating Databases on Different Partitions |
Date: | 2006-05-30 16:04:03 |
Message-ID: | bf05e51c0605300904u7e40a7fbs832abbd1a2ce88ff@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I think the tablespace option will work best - I will check it out. I do
not give the users control of the database since I do the development, I
just need a way to allocate the space and charge for space used. Since
cPanel monitors user space, I don't want to rely on having to query the
database to get size information - I would have to put together separate
scripts to watch space usage which I would rather not do.
Thanks for the help!
-Aaron
On 5/30/06, Andy Shellam <andy(dot)shellam(at)mailnetwork(dot)co(dot)uk> wrote:
>
> Hi Aaron
>
>
>
> I believe you could probably do this best with table spaces. You'll have
> to look it up in the documentation as I haven't done it for a while.
>
> You symlink a directory under <pgdata>/pg_tblspc to another physical
> directory (eg. Your user's home/db directory), then when you create the
> database, set its default table space to which directory you create.
>
>
>
> There is a downside in that the user could create a new table and override
> the table space to that of another user.
>
>
>
> You could always query the system catalogues for the usage for each user's
> database and add that to the physical size of their home directory?
>
>
>
> Regards,
>
>
>
> Andy
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Shellam | 2006-05-30 16:36:56 | Re: Separating Databases on Different Partitions |
Previous Message | Tom Lane | 2006-05-30 15:44:08 | Re: Separating Databases on Different Partitions |