Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TPF2r-0002Dw-RA for pgsql-performance@postgresql.org; Fri, 19 Oct 2012 16:03:33 +0000 Received: from smtp.optionshouse.com ([38.98.137.6] helo=smtp.peak6.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TPF2n-00009I-9N for pgsql-performance@postgresql.org; Fri, 19 Oct 2012 16:03:33 +0000 X-AuditID: 0a64cb1e-b7fd36d00000120f-a2-508179c59005 Message-ID: <508179CE.2040906@optionshouse.com> Date: Fri, 19 Oct 2012 11:03:26 -0500 From: Shaun Thomas Reply-To: Organization: Peak6 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20121011 Thunderbird/16.0.1 MIME-Version: 1.0 To: Karl Denninger CC: Claudio Freire , delongboy , Subject: Re: How to upgrade from 9.1 to 9.2 with replication? References: <1350598882643-5728941.post@n5.nabble.com> <50816749.6010804@denninger.net> <50817685.3060207@denninger.net> In-Reply-To: <50817685.3060207@denninger.net> Content-Type: text/plain; charset="ISO-8859-1"; format=flowed content-transfer-encoding: 7bit X-Originating-IP: [10.10.201.64] X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFlrAKsWRmVeSWpSXmKPExsXClcIroXu0sjHA4F27pcW9H1fYLJ78amK1 uD7zHLPFrQtrWB1YPNYf/MbksXPWXXaPC/umsXtMW76LOYAlqoHRJjEvL78ksSRVISW1ONlW yb+gJDM/r9gjv7Q4VcElszg5JzEzN7VISSEzxVbJXEmhICcxOTU3Na/EVimxoCA1L0XJjksB A9gAlWXmKaTmJeenZOal2yp5BvvrWliYWuoaKtnFI4OETpaMw1e3MxYsZ6k4f+sYewPjHuYu Rk4OCQETiR8nG6BsMYkL99azdTFycPAK6EvsnFEPEmYRUJXo7/zMCGKzCehKTOpfwQZiCwmo SPSdvcEEYvMLCEvs+9AENkZUIExi+c7NYHFeAUGJkzOfsIDYIgLqEosWrgSrYRYolbjZ+5QV xBYWcJc41v8TyOYCmrmXUeLc3eOMIDdwAi07uygcot5W4sKc6ywQtrzE9rdzmCFuUJVY0TyR DeJ8BYn/V94xTWAUmoVk9Swk7bOQtC9gZF7FKF5clpickWlaUJxbUmCoV5CamG2ml5dasokR HN+n5XYwTl+qeIhRgINRiYc34F5DgBBrYllxZe4hRgkOZiURXjf2xgAh3pTEyqrUovz4otKc 1OJDjMnAMJvILCWanA9MPXkl8YbGhpamliZmlubGxgakCSuJ89r2KQUICaQD0052ampBahHM FiYOTqkGRpMJCz++tW38yrRh77zzSWcVZq7R1fbRiNKdniEe+eDcx8lzK6XXTnvyj9Hi15eX NZwOBt8nynDL8F+57mzXuNPxqv+Nx9meZhIP9siHfvkg+i2y/WWnRu5c+RdG3McW1CQsOP4r zvPnlu+1Mu9fzvosufzu/OViF19Urtpl+tGA8YjY+2u9mqJKLMUZiYZazEXFiQCWT9gDMwMA AA== X-Pg-Spam-Score: -2.3 (--) X-Archive-Number: 201210/275 X-Sequence-Number: 48234 On 10/19/2012 10:49 AM, Karl Denninger wrote: > That's an interesting idea that might work; are replicated servers in a > consistent state guaranteed to have byte-identical filespaces? (other > than the config file(s), of course) I have not checked that assumption. Well, if they didn't before, they will after the rsync is finished. Update the config and start as a slave, and it's the same as a basebackup. -- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604 312-444-8534 sthomas@optionshouse.com ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email