X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 05BA39DC878 for ; Thu, 23 Mar 2006 17:21:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31469-06 for ; Thu, 23 Mar 2006 17:21:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from polaris.pinpointresearch.com (66-7-238-130.cust.telepacific.net [66.7.238.130]) by postgresql.org (Postfix) with ESMTP id E17659DC835 for ; Thu, 23 Mar 2006 17:21:10 -0400 (AST) Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id D276BE3CB923; Thu, 23 Mar 2006 13:21:12 -0800 (PST) Message-ID: <44231148.4040804@pinpointresearch.com> Date: Thu, 23 Mar 2006 13:21:12 -0800 From: Steve Crawford User-Agent: Mozilla Thunderbird 1.0 (X11/20041207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Pallav Kalva CC: pgsql-admin@postgresql.org Subject: Re: Archive Command Configuration References: <4422FD80.5080009@livedatagroup.com> <442304F9.4090708@pinpointresearch.com> <44230BBC.7080406@livedatagroup.com> In-Reply-To: <44230BBC.7080406@livedatagroup.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.131 required=5 tests=[AWL=0.131] X-Spam-Score: 0.131 X-Spam-Level: X-Archive-Number: 200603/223 X-Sequence-Number: 20980 > 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