Re: [PERFORM] PostgreSQL PITR - more doubts

2010-07-12 Thread Kevin Grittner
Jayadevan M wrote: >> Yes, It starts out form "where it needs to". Assuming you >> did a pg_start_backup() before you did your base backup? > > Thanks. I did. > It uses files like 000B00D9.0020.backupto get > the necessary information? Yeah, since it's a text file, you ca

Re: [PERFORM] PostgreSQL PITR - more doubts

2010-07-12 Thread Jayadevan M
> Yes, It starts out form "where it needs to". Assuming you >did a pg_start_backup() before you did your base backup? Thanks. I did. It uses files like 000B00D9.0020.backupto get the necessary information? Regards, Jayadevan DISCLAIMER: "The information in this e-mail

Re: [PERFORM] PostgreSQL PITR - more doubts

2010-07-12 Thread Jesper Krogh
On 2010-07-12 13:23, Jayadevan M wrote: Hello all, One doubt about how PostgreSQL PITR works. Let us say I have all the archived WALs for the past week with archive_command = 'cp -i %p /home/postgres/archive/%f Yes, It starts out form "where it needs to". Assuming you did a pg_start_backup()