Re: databases limit

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: fabio(at)gashost(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: databases limit
Date: 2003-02-06 01:23:02
Message-ID: 20030206012302.GA11406@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Wed, Feb 05, 2003 at 18:48:44 -0200,
Fabio Angeluci Martins <famartins(at)gashost(dot)com> wrote:
> Hi,
>
> What/Where i need set/configure to limit the numbers of databases which a
> normal user can create?

Either a user can create as many databases as they want or they can't create
any. If you use createuser to create the user you will get asked which
of the cases to apply to the user.
In recent versions of postgres the superuser can create a database that
is owned by another user. So if users don't need too many or to have them
created instantly, have them send requests to a superuser to create them
on there behalf.
In 7.3 schemas were added and this might allow you to limit each user
to one (or just a few) databases, depending on what your are trying to
achieve.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cornelia Boenigk 2003-02-06 02:42:51 Re: IN() alternatives
Previous Message Chris Travers 2003-02-06 00:54:39 Re: Deleting orphan records

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-02-06 01:54:03 Re: PostgreSQL, NetBSD and NFS
Previous Message Curt Sampson 2003-02-06 00:53:06 Re: PGP signing releases