I have a basic and quick question related to "archive_timeout" command in
I've set "archive_timeout" to 1800 seconds (30 minutes) in
"postgresql.conf", which means WAL archives are generated every 30 minutes.
So, if for an example my WAL archives are generated at the following time:
11:00 am, etc.
I specify PITR recovery time at 10:15 am in "recovery.conf". My question
is, to what time my database is recovered back? At which stage of the
following my database is reverted back:
1) Exactly the database was at 10:15 am
2) Exactly the database was at 10:00 am, because the last WAL archive
before 10:15 am was at 10:00 am.
View this message in context: http://www.nabble.com/PITR-archive_timeout-Command-tp24788681p24788681.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
pgsql-admin by date
|Next:||From: Ian Lea||Date: 2009-08-03 11:17:12|
|Subject: Re: PITR archive_timeout Command|
|Previous:||From: Fabricio||Date: 2009-08-03 00:17:40|
|Subject: Re: out of memory|