Re: "-t template0" in createdb

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

http://www.postgresql.org/docs/9.0/static/manage-ag-templatedbs.html

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