pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thomas Good <tomg@admin.nrnet.org>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Cleaning up template 1
Date: Mon, 25 Mar 2002 15:58:31 -0500 (EST)
Message-ID: <Pine.LNX.4.05.10203251551001.12366-100000@admin.nrnet.org> (raw)
In-Reply-To: <web-838475@davinci.ethosmedia.com>

On Mon, 25 Mar 2002, Josh Berkus wrote:

> Folks,
> 
> Due to an accident with a script, I created about 200 objects in the
>  template1 database instead of the database for which they were
>  intended.  
> I am now faced with either deleting each of these object individually,
>  or dumping my whole postgresql installation and re-installing each
>  user database, one at a time.
> 
> Can anyone suggest any shortcuts for fixing this problem?

Josh,

Isn't template0 around for events like this?  (maybe if template1 
goes missing, etc...)

I read somewhere that you can drop template1 and recreate it from 
template0...

Tom

------------------------------------------------------------------------
Thomas Good                                         tomg@admin.nrnet.org
Programmer/Analyst                                  phone:  718-818-5528
Residential Services, Behavioral Health Services    fax:    718-818-5056
Saint Vincent Catholic Medical Centers              mobile: 917-282-7359
--                                                                    --
SQL Clinic - An Open Source Clinical Record            www.sqlclinic.net
------------------------------------------------------------------------




view thread (7+ messages)  latest in thread

Message-ID: <Pine.LNX.4.05.10203251551001.12366-100000@admin.nrnet.org>
Permalink:  ../Pine.LNX.4.05.10203251551001.12366-100000@admin.nrnet.org/
Also on:    postgresql.org/message-id/Pine.LNX.4.05.10203251551001.12366-100000@admin.nrnet.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: tomg@admin.nrnet.org, josh@agliodbs.com
  Subject: Re: Cleaning up template 1
  In-Reply-To: <Pine.LNX.4.05.10203251551001.12366-100000@admin.nrnet.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox