Re: [ADMIN] General queries regarding backup

2009-07-29 Thread Peter Eisentraut
On Wednesday 22 July 2009 08:25:36 Deepak Bala wrote: Hi everyone, I have some queries regarding the PITR backup procedure on Postgres 8.3. Here are the steps I follow for backup 1. I set up WAL archiving and checked that this is working. 2. Execute SELECT pg_start_backup('label') 3. Zip

Re: [ADMIN] General queries regarding backup

2009-07-29 Thread Deepak Bala
Thanks for your replies Peter. On Wed, Jul 29, 2009 at 12:45 PM, Peter Eisentrautpete...@gmx.net wrote: On Wednesday 22 July 2009 08:25:36 Deepak Bala wrote: Hi everyone, I have some queries regarding the PITR backup procedure on Postgres 8.3. Here are the steps I follow for backup 1. I

Re: [ADMIN] General queries regarding backup

2009-07-28 Thread Deepak Bala
Anyone ? On Wed, Jul 22, 2009 at 10:55 AM, Deepak Baladeepak.bal...@gmail.com wrote: Hi everyone, I have some queries regarding the PITR backup procedure on Postgres 8.3. Here are the steps I follow for backup 1. I set up WAL archiving and checked that this is working. 2. Execute SELECT

[ADMIN] General queries regarding backup

2009-07-22 Thread Deepak Bala
Hi everyone, I have some queries regarding the PITR backup procedure on Postgres 8.3. Here are the steps I follow for backup 1. I set up WAL archiving and checked that this is working. 2. Execute SELECT pg_start_backup('label') 3. Zip the entire data directory excluding the pg_xlog directory. 4.

[ADMIN] General queries regarding backup

2009-07-22 Thread Deepak Bala
Hi everyone, I have some queries regarding the PITR backup procedure on Postgres 8.3. Here are the steps I follow for backup 1. I set up WAL archiving and checked that this is working. 2. Execute SELECT pg_start_backup('label') 3. Zip the entire data directory excluding the pg_xlog directory. 4.