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 go
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 pg_start_b
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, but,