Re: global.bki vs template1.bki init files - Mailing list pgsql-hackers

From Tom Lane
Subject Re: global.bki vs template1.bki init files
Date
Msg-id 8667.992357654@sss.pgh.pa.us
Whole thread Raw
In response to Re: global.bki vs template1.bki init files  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Somehow I got marked down for this but I actually thought the split was
> useful.  One reason was that you could restore template1 individually
> (which hasn't worked for a while).

If it ever did, which seems doubtful given the way build_indices works;
there's no way to build only a subset of the existent indices.

Anyway, we have a superior solution for that problem now: you can delete
template1 and clone it from template0.  (Yes, that actually works...
at least it does if you have another database you can connect to while
issuing the DROP DATABASE and CREATE DATABASE commands...)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: global.bki vs template1.bki init files
Next
From: Thomas Lockhart
Date:
Subject: Re: [PATCHES] Australian timezone configure option