From: | Murthy Nunna <mnunna(at)fnal(dot)gov> |
---|---|
To: | desmodemone <desmodemone(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: PITR |
Date: | 2014-02-22 17:03:23 |
Message-ID: | BD7563973EF8894D905C80593EE9A4ED330E2F@MAIL01.fnal.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Mat,
Thank you for your quick response....
The documentation says for pause_at_recovery_target:
This setting has no effect if hot_standby<http://www.postgresql.org/docs/9.2/static/runtime-config-replication.html#GUC-HOT-STANDBY> is not enabled, or if no recovery target is set.
In my case hot_standby is not enabled.
Thanks,
Murthy
From: desmodemone [mailto:desmodemone(at)gmail(dot)com]
Sent: Saturday, February 22, 2014 10:34 AM
To: Murthy Nunna
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] PITR
2014-02-22 17:06 GMT+01:00 Murthy Nunna <mnunna(at)fnal(dot)gov<mailto:mnunna(at)fnal(dot)gov>>:
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
Hi Murthy,
look at parameter "pause_at_recovery_target" and "recovery_target_time" with these parameters in the recovery.conf you could reach a point in the timeline to recover the database and then see if it's all ok and then finish the recovery with pg_xlog_replay_resume. If you want instead continue the recovery you have to stop the backend and change the parameter of recovery_target_time in the recovery.conf and restart the postmaster.
Mat DBA
From | Date | Subject | |
---|---|---|---|
Next Message | Julien Rouhaud | 2014-02-22 17:31:51 | Re: PITR |
Previous Message | desmodemone | 2014-02-22 16:33:32 | Re: PITR |