Re: Separating Databases on Different Partitions

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
>