Search Postgresql Archives

Re: PITR Questions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Aug 03, 2006 at 05:03:35PM -0400, Matthew T. O'Connor wrote:
> I have it set as follows:
> archive_command = 'rsync -a %p backup_server:/pgsql_pitr/%f'
> 
> Any comments as to whether or not this is a *good* choice?

Are you also doing the dance with pg_start_backup(), doing a file copy
of main, and then pg_stop_backup()?  That's your full backup; the PITR
files are something like incremental backups and need the copy of main
to play against.

        Wayne Conrad


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux