Probably a silly question but if I restore with pg_restore to an
existing database I get several messages 'primary key violation' ...
clearly if I restore to a database I create for the occasion, this
does not happen.
Is it a good practice in order to have a reasonable level of security
to on a server drop and recreate a database every day ? would there be
any side effects things that could get corrupted in the long term. We
want to restore because we are using a separate server for the heavy
re****ting we have so we are planning to backup and restore at least
every night.
Thanks for your thoughts
Didier
--
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
