Re: [GENERAL] Queries about PostgreSQL PITR

2010-07-12 Thread Fujii Masao
On Mon, Jul 12, 2010 at 5:29 PM, Jayadevan M wrote: > Hi, >>Because you didn't disable recovery_target_inclusive, I guess. >> > http://www.postgresql.org/docs/8.4/static/continuous-archiving.html#RECOVERY-TARGET-INCLUSIVE > Thanks. I was almost sure this will fix it. But the issue seems to be > so

Re: [GENERAL] Queries about PostgreSQL PITR

2010-07-12 Thread Jayadevan M
Hi, >Because you didn't disable recovery_target_inclusive, I guess. > http://www.postgresql.org/docs/8.4/static/continuous-archiving.html#RECOVERY-TARGET-INCLUSIVE Thanks. I was almost sure this will fix it. But the issue seems to be something else. Even if I give a time that is a few more minutes

Re: [GENERAL] Queries about PostgreSQL PITR

2010-07-11 Thread Fujii Masao
On Fri, Jul 9, 2010 at 6:47 PM, Jayadevan M wrote: > So recovery happened to a point after I dropped the first table and before > I dropped > the second table. Why ? Because you didn't disable recovery_target_inclusive, I guess. http://www.postgresql.org/docs/8.4/static/continuous-archiving.html#

[GENERAL] Queries about PostgreSQL PITR

2010-07-09 Thread Jayadevan M
Hello all, I am learning PostgreSQL PITR. I have PostgreSQL running with the following parameters set up for archiving/log switching: archive_mode = on archive_command = 'cp -i %p /home/postgres/archive/%f http://www.postgresql.org/mailpref/pgsql-general