Re: Archive Command Configuration

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Pallav Kalva <pkalva(at)livedatagroup(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Archive Command Configuration
Date: 2006-03-23 21:21:12
Message-ID: 44231148.4040804@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> Hi Steve,
>
> Thanks! for the quick reply, I thought about rsync too, but wasnt
> sure about completely how it handles partial files. I use rsync for all
> the backups, it works fine for all the application except for our mail
> application it copies the files but at the end of the job it gives me
> message like
>
> ------------------------------------------------------------------------------------
>
> send_files failed to open //this/file/ : No such file or directory
>
> rsync error: some files could not be transferred (code 23) at main.c(1158)
> ------------------------------------------------------------------------------------
>
>
> Considering it is copying all our mail messages and it takes a lot of
> time to rsync the whole thing, there might be changes to the file or
> file gets deleted completely from time it gets the files to rsync and do
> the actual rsync.

Not to worry. I see this from time to time as well. Rsync builds a list
of files to sync and then syncs them. If a file is deleted between the
time rsync builds the list and when it tries to process that file, it
will return that error.

BTW, if you haven't done so already, check out version 2.6.7 released a
week or so ago. There are some nice enhancements to the include/exclude
code, a --prune-empty-dirs option so when your exclude options eliminate
all the files in a directory you don't end up creating an empty
directory on the target machine, and an --append option to improve
efficiency when transferring files that are only appended to, not
changed (great for logs and such).

Cheers,
Steve

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gregory Maxwell 2006-03-24 01:16:09 Bloated pg_shdepend_depender_index
Previous Message Pallav Kalva 2006-03-23 20:57:32 Re: Archive Command Configuration