Re: Template1 oops

On Wed, Sep 13, 2006 at 10:56:41AM +0200, Alban Hertroys wrote:

>>I found an oops in one of our template1 databases; tables and stuff were
>>apparently loaded into the wrong database (namely template1). I found
>>this page describing a solution:
>>http://techdocs.postgresql.org/techdocs/pgsqladventuresep1.php
>>
>>But, this looks kind of risky to me. I'd prefer not to put our running
>>databases at risk.
>>
>>As an alternative approach, wouldn't dropping and recreating the public
>>schema be a nice alternative? And in that case, what would be the right
>>CREATE SCHEMA public command? I don't feel like messing this up ;)
>>
>>

I'm humble (or naive) enough to admit that I've used the approach
outlined there by Josh Berkus, and it worked fine. More than once, even.

Regards,
BMT