Postgres Pro
Downloads
Home   >   mailing lists

Thread: Recovery with WAL

Recovery with WAL

From
Albert
Date:

Where can I find information about recovery_target_time or
recovery_target_xid. I have two servers db1 and db2,
WAL files are copied from db1 to db2. Database will colapse at 17:10 and
i wan't to recove base from 17:05, so where can I find info about
recovery_time.



Albert

Re: Recovery with WAL

From
Bruce Momjian
Date:
Albert wrote:
>
>
> Where can I find information about recovery_target_time or
> recovery_target_xid. I have two servers db1 and db2,
> WAL files are copied from db1 to db2. Database will colapse at 17:10 and
> i wan't to recove base from 17:05, so where can I find info about
> recovery_time.

If you use no recovery time or xid, it will go as far as it can.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +