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

Re: recovering using a continuous archive backup doesn'twork on Windows

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: recovering using a continuous archive backup doesn'twork on Windows
Date: 2007-03-30 13:31:58
Message-ID: 1175261519.4386.770.camel@silverbirch.site (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, 2007-03-29 at 18:18 +0300, Sabin Coanda wrote:

> The problem still persist, and I'm not able to fix it alone.
> Is anyone which is using WAL on Windows to tell me some tips to make it 
> workable, or to confirm there is a problem, please ?

>From your earlier problem description you seem to be attempting to run
two databases on one server. That requires a custom install, though even
if you did this it definitely would not provide you with any of the
outcomes you might want to create:

Are you trying to
a) run a backup with continuous archiving
http://www.postgresql.org/docs/8.2/static/continuous-archiving.html#BACKUP-ARCHIVING-WAL

b) run a restore from a continuous archive backup
http://www.postgresql.org/docs/8.2/static/continuous-archiving.html#BACKUP-PITR-RECOVERY

c) run a Warm Standby between two database servers
http://www.postgresql.org/docs/8.2/static/warm-standby.html

If you want to do (a) or (b) you've mistakenly read both parts of the
manual and if you want to do (c) then you need two servers, not just
one.

-- 
  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com



In response to

Responses

pgsql-admin by date

Next:From: Warren LittleDate: 2007-03-30 14:23:06
Subject: Re: trying to run PITR recovery
Previous:From: Sorin N. CiolofanDate: 2007-03-30 13:20:09
Subject: Re: ERROR: out of shared memory

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