Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YoDyi-0004DK-9v for pgsql-hackers@arkaria.postgresql.org; Fri, 01 May 2015 16:39:52 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YoDyh-0003Ju-Pj for pgsql-hackers@arkaria.postgresql.org; Fri, 01 May 2015 16:39:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YoDyg-0003I3-3m for pgsql-hackers@postgresql.org; Fri, 01 May 2015 16:39:50 +0000 Received: from lists.commandprompt.com ([69.168.55.30]) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1YoDyc-0005Dv-Ec for pgsql-hackers@postgresql.org; Fri, 01 May 2015 16:39:49 +0000 Received: from [192.168.1.3] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 6366C364; Fri, 1 May 2015 09:39:44 -0700 (PDT) Received: from [192.168.1.3] ([67.168.169.165] helo=[192.168.1.3]) by assp.commandprompt.com with ESMTPS(AES128-SHA) (2.1.1); 1 May 2015 09:39:44 -0700 Message-ID: <5543AC52.9060806@commandprompt.com> Date: Fri, 01 May 2015 09:39:46 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.6.0 MIME-Version: 1.0 To: Andres Freund CC: pgsql-hackers Subject: Re: Replication, am I missing something References: <5543A8B1.4060903@commandprompt.com> <20150501162821.GD16366@awork2.anarazel.de> In-Reply-To: <20150501162821.GD16366@awork2.anarazel.de> Content-Type: text/plain; charset=windows-1252; 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-98384-05795 X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: pgsql-hackers@postgresql.org X-Assp-Original-Subject: Re: [HACKERS] Replication, am I missing something X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 05/01/2015 09:28 AM, Andres Freund wrote: > > On 2015-05-01 09:24:17 -0700, Joshua D. Drake wrote: >> Origin: select pg_start_backup('my_backup',TRUE); >> Subscriber: rsync -auvk db1:/var/lib/pgsql/data data >> Origin: select pg_stop_backup(); >> Subscriber: remove backup_label >> Subscriber: start postgresql Ignore the noise here. I realize I missed a step and added a step. Sorry about that. JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone else should do it for you. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers