Skip site navigation (1) Skip section navigation (2)

Re: "-t template0" in createdb

From: Mike Thomsen <mikerthomsen(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: "-t template0" in createdb
Date: 2011-02-03 19:57:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Interesting. Your docs say to use "-T template0" I have a feeling that
our instructions had a typo which caused the grief^H^Hfun I was

At any rate, if all I need is a bit bucket, is there a practical
difference between leaving it on versus off when running createdb?

On Thu, Feb 3, 2011 at 1:27 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Mike Thomsen <mikerthomsen(at)gmail(dot)com> writes:
>> I while ago, I reported that grant statements were always returning an
>> error stating that the database could no be found.
>> Today I noticed that it seemed to be caused only when the database was
>> created like this:
>> createdb newdb -U postgres -t template0
>> The installation instructions we got for an inhouse project called for
>> the "-t template0" When removed, that consistently caused the
>> aforementioned bug to stop.
>> What was it about that "-t template0" that was causing it to fail?
> If you don't say "-t template0" then what you get is a database cloned
> from template1 instead of template0.  It sounds to me like you have
> (either intentionally or accidentally) added some objects to template1,
> and your code is relying on those objects being there in a newly-created
> database.  See
> Whether having extra stuff in template1 is a good thing or not is
> something that depends on your individual situation ... but a lot of
> people have found it to be a foot-gun.
>                        regards, tom lane

In response to


pgsql-novice by date

Next:From: Tom LaneDate: 2011-02-03 22:29:35
Subject: Re: "-t template0" in createdb
Previous:From: Tom LaneDate: 2011-02-03 18:27:06
Subject: Re: "-t template0" in createdb

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group