| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | Pallav Kalva <pkalva(at)livedatagroup(dot)com> |
| Cc: | Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Archive Command Configuration |
| Date: | 2006-03-24 16:45:31 |
| Message-ID: | 20060324164530.GT90527@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, Mar 24, 2006 at 10:39:41AM -0500, Pallav Kalva wrote:
> What do you think about this option ? If I just do scp from the
> /archives folder, I will be ok and wont copy any partial files at any
> time right ?
> archive_command = 'cp %p /archives-temp/%f && mv /archives-temp/%f
> /archives/%f'
A simple scp leaves you vulnerable to a WAL file only being partially
copied if a backhoe hits at just the right moment. I believe that
wouldn't be an issue with rsync, since it won't put a file in place
until it's completely transfered. So if you want to use scp, I think
you'd need to scp to a temporary directory, and then do a final move.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pallav Kalva | 2006-03-24 17:12:54 | Re: Archive Command Configuration |
| Previous Message | Jim C. Nasby | 2006-03-24 16:43:26 | Re: Bloated pg_shdepend_depender_index |