From: | Manlio Perillo <manlio(dot)perillo(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | restoring a database to its initial state |
Date: | 2010-03-13 12:48:14 |
Message-ID: | 4B9B898E.5000003@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----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.
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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2010-03-13 13:26:28 | Re: restoring a database to its initial state |
Previous Message | Angel | 2010-03-13 11:54:09 | Hints for postgresql package recompilation (FIXED) |