Re: default database creation with initdb - Mailing list pgsql-patches

From Tom Lane
Subject Re: default database creation with initdb
Date
Msg-id 12287.1119101599@sss.pgh.pa.us
Whole thread Raw
In response to default database creation with initdb  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-patches
Andreas Pflug <pgadmin@pse-consulting.de> writes:
> +        "CREATE DATABASE \"default\";\n",
> +        "REVOKE CREATE,TEMPORARY ON DATABASE \"default\" FROM public;\n",

Uh, why the rights revocation?  That makes the thing essentially useless
... except to superusers, who will not be affected anyway.  I don't
think this is a sane default.

In any case, fixing initdb for this is trivial.  I count something north
of 160 other references to template1 in the current sources, scattered
across 60+ files.  Every one of those has to be looked at and possibly
changed.

            regards, tom lane

pgsql-patches by date:

Previous
From: Robert Treat
Date:
Subject: Re: default database creation with initdb
Next
From: Andreas Pflug
Date:
Subject: Re: default database creation with initdb