Re: restoring a database to its initial state

Hello

2010/3/13 Manlio Perillo <manlio.perillo@gmail.com>:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi.
>
> 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.
>
> By initial state I mean:
>  The content of template1 database
> or
>  The database without all objects owned by role X, and that can be
>  re-created by X
>
> where X is a role with normal privileges.
>
>
> I searched on pgFoundry, without success.
>
> It should not be hard to implement, but I would like to know if
> something similar has already been implemented.
>
>

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

Regards
Pavel Stehule

>
> Thanks  Manlio
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.10 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iEYEARECAAYFAkubiY4ACgkQscQJ24LbaURhBgCdHHSop6sxE1iGhGScLgQxTs0y
> F54An3uYbIA5NqXIb79n1IQZA4cKb7XQ
> =sooF
> -----END PGP SIGNATURE-----
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>