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
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: Mike Thomsen||Date: 2011-02-03 19:57:03|
|Subject: Re: "-t template0" in createdb|
|Previous:||From: Mike Thomsen||Date: 2011-02-03 18:04:49|
|Subject: "-t template0" in createdb|