From: | nick <nicktjh(at)solutionx(dot)com(dot)my> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Restoring DB using Continuous Archive Backup |
Date: | 2008-03-28 04:15:05 |
Message-ID: | 001501c8908a$4f3180b0$1502a8c0@sx54370ba31fad |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thanks for the reply, ashish.
Sorry, should’ve been more specific.
By running WAL, I mean reprocessing the WALs up to a certain point of time.
For example:
A backup is made at 0000 hours. Something happens. Restore has to be made at
2000.
Since the backup is at 0000, 20 hours’ worth of transactions will be stored
in WAL. To get the data up to the 2000 the WALs have to be reprocessed. I
realize the only way for this to work is by data file duplication, so this
mean the service has to be stopped anyway to allow the files to be restored.
But there may be a requirement to not take the system offline so I’m looking
for a method to do the restore and WAL reprocessing without stopping then
starting the service like described in the manual.
It would be of great help if it’s possible.
Thanks in advance,
Nick
_____
From: ashish [mailto:ashish(dot)karalkar(at)netcore(dot)co(dot)in]
Sent: Thursday, March 27, 2008 7:40 PM
To: nick
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Restoring DB using Continuous Archive Backup
nick wrote:
Hi everyone,
I just got PGSQL up and running yesterday. One of the features that intrigue
me is the WAL. I am running tests to perform DB restores using WAL. The last
attempt ended in disaster and a reinstall.
This may sound retarded. I can’t seem to get a clear picture from the
manual. I quote (Chapter 24.3.3 Step 4):
Restore the database files from your backup dump. Be careful that they are
restored with the right
ownership (the database system user, not root!) and with the right
permissions. If you are using
tablespaces, you should verify that the symbolic links in pg_tblspc/ were
correctly restored.
I need to know which kind of backup (as there are multiple suggested in the
manual) would that (underlined) be referring to?
File system level backup
Is there a way to detach/attach databases (like ms-sql) and so perform
restoration on only one database instead of bringing down the service?
As far as i think the answer is NO
Is there a method to re-run WAL after restoring an old backup without
resorting to a service stop-start?
Not clear need more info.
Thanks in advance,
Nick
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1345 - Release Date: 3/26/2008
6:50 PM
===================================================================
sms START NETCORE to 575758 to get updates on Netcore's enterprise
products and services
sms START MYTODAY to 09845398453 for more information on our mobile
consumer services or go to http://www.mytodaysms.com
===================================================================
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1345 - Release Date: 3/26/2008
6:50 PM
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1345 - Release Date: 3/26/2008
6:50 PM
From | Date | Subject | |
---|---|---|---|
Next Message | salman | 2008-03-28 04:59:29 | Re: Restoring DB using Continuous Archive Backup |
Previous Message | Martin Marcher | 2008-03-27 18:13:29 | Documentation Tool |