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

Re: [HACKERS] Re: New init script and upgrade attempt: failed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
Cc: dale(at)redhat(dot)com, pgsql-hackers(at)postgresql(dot)org, jbj(at)redhat(dot)com
Subject: Re: [HACKERS] Re: New init script and upgrade attempt: failed
Date: 1999-09-27 23:35:40
Message-ID: 27940.938475340@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> writes:
> Hackers:  should pg_dumpall dump template1??  If not, why not?  What
> EXACTLY does template1 do in the larger scheme of things? If dumping
> template1 is desired -- it can be arranged in the upgrade by modifying
> pg_dumpall.

template1 is copied verbatim by CREATE DATABASE to produce the initial
state of any new database.  So, people might reasonably put stuff in
it that they want copied to new DB's.  The most common example is
doing a createlang to create non-default PLs (plpgsql etc); you can do
it just once in template1 instead of every time you make a DB, assuming
that you want plpgsql in all your DBs.  I guess there could be reasons
for making a user table in template1 to be copied to each new DB.

If pg_dumpall doesn't dump the (user-added) contents of template1,
I think that's an oversight...

			regards, tom lane

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 1999-09-27 23:37:43
Subject: Re: [HACKERS] Profiling?]
Previous:From: Tom LaneDate: 1999-09-27 23:30:51
Subject: Re: [HACKERS] _text problem in union

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