Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WSTBx-0004SI-T9 for pgsql-performance@arkaria.postgresql.org; Tue, 25 Mar 2014 15:23:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WSTBx-0003Iy-C8 for pgsql-performance@arkaria.postgresql.org; Tue, 25 Mar 2014 15:23:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WSTBv-0003Gu-Ib for pgsql-performance@postgresql.org; Tue, 25 Mar 2014 15:23:03 +0000 Received: from lists.commandprompt.com ([69.168.55.30]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WSTBn-0007RG-UC for pgsql-performance@postgresql.org; Tue, 25 Mar 2014 15:23:02 +0000 Received: from [192.168.1.5] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 1276A71F; Tue, 25 Mar 2014 08:22:53 -0700 (PDT) Received: from [192.168.1.5] ([71.95.106.58] helo=[192.168.1.5]) by assp.commandprompt.com with ESMTPS(AES128-SHA) (2.1.1); 25 Mar 2014 08:22:53 -0700 Message-ID: <53319F4F.3000005@commandprompt.com> Date: Tue, 25 Mar 2014 08:22:55 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.3.0 MIME-Version: 1.0 To: ik@postgresql-consulting.com CC: Claudio Freire , David Johnston , postgres performance list Subject: Re: pg_dump vs pg_basebackup References: <1395722709.28433.YahooMailNeo@web161601.mail.bf1.yahoo.com> <1395733159787-5797364.post@n5.nabble.com> <5331992D.9010603@commandprompt.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.1.1(11364) on assp.commandprompt.com X-Assp-Client-SSL: yes X-Assp-ID: assp.commandprompt.com m1-60973-04106 X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: ik@postgresql-consulting.com X-Assp-Original-Subject: Re: [PERFORM] pg_dump vs pg_basebackup X-Pg-Spam-Score: -2.3 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 03/25/2014 08:18 AM, Ilya Kosmodemiansky wrote: > > Joshua, > > that is really good point: an alternative is to use pg_basebackup > through ssh tunnel with compression, but rsync is much simpler. Or rsync over ssh. The advantage is that you can create backups that don't have to be restored, just started. You can also use the differential portions of rsync to do it multiple times a day without much issue. JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579 PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc Political Correctness is for cowards. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance