From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Manlio Perillo <manlio(dot)perillo(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: restoring a database to its initial state |
Date: | 2010-03-13 13:26:28 |
Message-ID: | 162867791003130526n16cd21b4h8c62b429609fd80@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
2010/3/13 Manlio Perillo <manlio(dot)perillo(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian von Bidder | 2010-03-13 15:06:02 | Re: restoring a database to its initial state |
Previous Message | Manlio Perillo | 2010-03-13 12:48:14 | restoring a database to its initial state |