Re: pg_database datistemplate

From: korry <korry(at)starband(dot)net>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_database datistemplate
Date: 2002-10-24 20:29:53
Message-ID: 5.1.0.14.0.20021024162747.02b93eb8@pop.starband.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


>In the docs it is mentioned for datistemplate that
>
>"If true then this database can be used in the "TEMPLATE" clause of
>CREATE DATABASE to create the new database as a clone of this one."
>
>However, one can create a database using as template another DB that has
>datistemplate set to false.
>
>In this situation, what is the point of having datistemplate?

If datistemplate is true, any user with CREATEDB privileges can clone the
database.
If datistemplate is false, only a cluster superuser can clone the database.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hadley Willan 2002-10-24 20:39:12 Re: Hot Backup
Previous Message Tom Lane 2002-10-24 20:14:52 Do we still need NO_MKTIME_BEFORE_1970 ?