Re: [GENERAL] Postgresql-9.0.1 Recovery

2011-08-31 Thread Venkat Balaji
Thanks Craig ! Below is what i did - 1. pg_start_backup() 2. rsync the data dir 3. pg_stop_backup() I believe the backup is valid because, i was able to bring up the cluster without any issues (ofcourse with data loss). +ve signs- I am able to bring up the cluster with the Online backup,

[GENERAL] Postgresql-9.0.1 Recovery

2011-08-30 Thread Venkat Balaji
Hello Everyone, I have a situation here - I am trying to restore the production online backup and recover the same. - I had initially rsynced (excluded pg_log) the data directory and the tarred and zipped the same - SCP'd the tar to a different server and untarred and unzipped the same - I

Re: [GENERAL] Postgresql-9.0.1 Recovery

2011-08-30 Thread Craig Ringer
On 30/08/2011 6:59 PM, Venkat Balaji wrote: Hello Everyone, I have a situation here - I am trying to restore the production online backup and recover the same. - I had initially rsynced (excluded pg_log) the data directory and the tarred and zipped the same Did you do that after