Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VosIK-0006cG-Gc for pgsql-admin@arkaria.postgresql.org; Fri, 06 Dec 2013 10:06:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VosIK-0007D8-09 for pgsql-admin@arkaria.postgresql.org; Fri, 06 Dec 2013 10:06:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VosIJ-0007D2-BH for pgsql-admin@postgresql.org; Fri, 06 Dec 2013 10:05:59 +0000 Received: from benu2.louis.info ([80.70.184.127]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VosIG-0005Zd-PJ for pgsql-admin@postgresql.org; Fri, 06 Dec 2013 10:05:58 +0000 Received: from srvcom01.louis-net.de (243.199.116.85.in-addr.arpa.manitu.net [85.116.199.243]) by benu2.louis.info (Postfix) with ESMTPA id 2186F4552D for ; Fri, 6 Dec 2013 11:05:55 +0100 (CET) Received: from (127.0.0.1) by SRVCOM01.louis-net.de (127.0.0.1) with Microsoft SMTP Server id 14.3.158.1; Fri, 6 Dec 2013 11:05:54 +0100 Received: from [192.168.22.150] (192.168.22.150) by srvcom01.louis-net.de (192.168.22.6) with Microsoft SMTP Server id 14.3.158.1; Fri, 6 Dec 2013 11:05:54 +0100 Message-ID: Date: Fri, 6 Dec 2013 11:05:53 +0100 From: Boris Bukowski User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.1.1 MIME-Version: 1.0 To: Subject: Base Backups to a remote location Content-Type: text/plain; charset="utf-8"; format=flowed X-Originating-IP: [192.168.22.150] X-CI-MailPolicy-Key: 164af84311dbef8dc1e7e215bd953fbd Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -2.1 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org =EF=BB=BFHi, i use the following script to backup servers every day to a remote location. ---snip--- REMOTE=3Dxyz123.louis.info DATE=3D`date +%Y%m%d%H%M%S` ssh xyz123.louis.info "echo \"checkpoint; SELECT=20 pg_start_backup('${DATE}');\" |psql" rsync -avxz --numeric-ids --exclude-from=3D/backup1/config/excludes.txt=20 --delete-excluded --inplace --delete root@${REMOTE}:/=20 /mnt/backup1/remote/xyz123/full ssh xyz123.louis.info "echo \"SELECT pg_stop_backup();\" |psql" ---snip--- i have some questions about this: 1. will this always work? 2. between these backups i do not save the archive logs, is this secure? 3. is it save to empty the archive directory befor i do a backup with=20 pg_start_backup()? best Regards Boris Bukowski --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin