Re: restoring a database to its initial state

From: Adrian von Bidder <avbidder(at)fortytwo(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: restoring a database to its initial state
Date: 2010-03-13 15:06:02
Message-ID: 201003131606.11052@fortytwo.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hyho!

On Saturday 13 March 2010 13.48:14 Manlio Perillo wrote:

> Usually when I need to restore a database to its initial state, what I
> do is to simply drop it, and then re-create it.
>
> However on a shared hosting this is not possible.

Create a schema, modify your default search path so that you're always
working in your new schema, then you can just drop schema foo cascade;

cheers
-- vbi

--
Today is Boomtime, the 72nd day of Chaos in the YOLD 3176

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-03-13 16:20:54 Re: restoring a database to its initial state
Previous Message Pavel Stehule 2010-03-13 13:26:28 Re: restoring a database to its initial state