Re: restoring a database to its initial state

Pavel Stehule <pavel.stehule@gmail.com> writes:
> 2010/3/13 Manlio Perillo <manlio.perillo@gmail.com>:
>> 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.

> Usually people use a install and a uninstall scripts. First creates
> dbobjects, second removes objects.

"pg_dump --clean" can help with creating an uninstall script.

            regards, tom lane