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

Restoring DB using Continuous Archive Backup

From: nick <nicktjh(at)solutionx(dot)com(dot)my>
To: pgsql-novice(at)postgresql(dot)org
Subject: Restoring DB using Continuous Archive Backup
Date: 2008-03-27 10:21:43
Message-ID: 000301c88ff4$5d693fb0$1502a8c0@sx54370ba31fad (view raw or flat)
Thread:
Lists: pgsql-novice
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? 

 

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?

 

Is there a method to re-run WAL after restoring an old backup without
resorting to a service stop-start?

 

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
 

Responses

pgsql-novice by date

Next:From: Emil ObermayrDate: 2008-03-27 10:54:13
Subject: Re: Reuse serial numbers?
Previous:From: A BDate: 2008-03-27 10:17:51
Subject: Re: Reuse serial numbers?

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