Re: How can I recreate the template0 database?

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Eduardo Mambrilla Martínez <emambr(at)tid(dot)es>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How can I recreate the template0 database?
Date: 2005-03-14 15:59:14
Message-ID: 1110815954.28555.37.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 2005-03-09 at 01:32, Eduardo Mambrilla Martínez wrote:
> I made a mistake, I droped the template0 database...
> How can I recreate it?

Do you still have template1? If so, connect in single user mode, enter:
postgres template1
create database template0 with template template1
update pg_database set datallowconn = false where datname='template0';

Use CTRL-D to exit.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas F.O'Connell 2005-03-14 16:10:17 Re: Performance Question
Previous Message Thomas F.O'Connell 2005-03-14 15:58:53 Re: Performance Question