Re: Online Backup and WAL archives

>Pallav Kalva wrote
> yes, documentation points to the
> recovery_target_time(timestamp) option
> in this regard, sorry i missed that. but there is one thing which is
> still not clear to me is if we restore the database to some
> time back ,
> what happens to WAL files in the pg_xlog directory ?

>if we
> still keep
> those files there,

The manual asks you not to do this, in 22.3.3 step 5
so why wonder too much about what will happen?

> arent they out of sync ?

No.

> since we are
> going back in
> time and we dont need the WAL logs after the
> recovery_target_time(timestamp), or is it that restore command takes
> care everything automatically ? the manual doesnt clearly say what
> happens to the WAL logs in pg_xlog in case if we use the
> recovery_target_time(timestamp) option.

Read 22.3.4 and it will become clearer.

Better still, try it and see for yourself. About 3 times, so you're
certain you understand how it works before you begin using it and
relying on it.

The xlog filenames are prefixed by the timelineId, which prevents the
server from becoming confused about the files.

Best regards, Simon Riggs