Skip site navigation (1) Skip section navigation (2)

Re: restoring with pg_restore

From: "Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
To: "'Didier Gasser-Morlay'" <didiergm(at)gmail(dot)com>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: restoring with pg_restore
Date: 2008-04-23 23:34:45
Message-ID: 005001c8a59a$9d34d0d0$9b0014ac@wbaus090 (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
> 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 reporting we
have so we > are planning to backup and restore at least every night.

I'm a little lost - how would dropping and restoring your database each
night increase security? Do you mean security as in your data will be (more)
secure against data loss, as opposed to unauthorized access etc? 

The only benefits I can see is:
A) You will always know your backup is working (or not, as the case may be)
B) Your physical 'size on disk' will always be minimum possible as the
backend files on disk will be re-written and optimized every time you do it.

THINK BEFORE YOU PRINT - Save paper if you don't really need to print this

*******************Confidentiality and Privilege Notice*******************

The material contained in this message is privileged and confidential to
the addressee.  If you are not the addressee indicated in this message or
responsible for delivery of the message to such person, you may not copy
or deliver this message to anyone, and you should destroy it and kindly
notify the sender by reply email.

Information in this message that does not relate to the official business
of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta.
Weatherbeeta, its employees, contractors or associates shall not be liable
for direct, indirect or consequential loss arising from transmission of this
message or any attachments

In response to


pgsql-novice by date

Next:From: Didier Gasser-MorlayDate: 2008-04-24 08:21:55
Subject: Re: restoring with pg_restore
Previous:From: Didier Gasser-MorlayDate: 2008-04-23 16:21:16
Subject: restoring with pg_restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group