Re: Reloading Template1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Hadley Willan <hadley(dot)willan(at)deeperdesign(dot)co(dot)nz>, PGSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Reloading Template1
Date: 2004-01-27 16:28:18
Message-ID: 22602.1075220898@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton <dev(at)archonet(dot)com> writes:
> Actually, IIRC this is exactly why we have template0 -
> for those occasions where you want to regenerate template1.

Well, that's one of its uses.

IIRC there is a page on techdocs.postgresql.org that will walk you
through this procedure. There are a couple of safety interlocks you
need to defeat temporarily, so it's a bit more than a DROP and a CREATE.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-01-27 16:41:14 Re: Permission Problems:-)?
Previous Message Tom Lane 2004-01-27 16:25:35 Re: postmaster growing to consume all memory