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