PITR - Mailing list pgsql-admin

From Murthy Nunna
Subject PITR
Date
Msg-id BD7563973EF8894D905C80593EE9A4ED330E01@MAIL01.fnal.gov
Whole thread Raw
Responses Re: PITR  (desmodemone <desmodemone@gmail.com>)
List pgsql-admin

All,

 

I am testing PITR…. I am looking for recovery.conf parameters where you can recovery the WALs available in the restore_command but do not complete recovery. I want to be able to connect to the database and check database in read only and if I am not there yet, I will feed more WALs in the archive directory and resume recovery. I would like to prevent multiple base restorations. I want to roll forward with WALs but check in between. Also, I do not want to set up replication standby.

 

Is it possible? If so, could you tell me what are the relevant recovery.conf params?

 

Thanks,

Murthy

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Increasing maximum connection for postgresql 9.2
Next
From: desmodemone
Date:
Subject: Re: PITR