Hello 2010/3/13 Manlio Perillo <manlio.perillo@xxxxxxxxx>: > -----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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
