Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eKiZH-00071w-SV for pgsql-admin@arkaria.postgresql.org; Fri, 01 Dec 2017 10:29:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eKiZH-0007LB-4K for pgsql-admin@arkaria.postgresql.org; Fri, 01 Dec 2017 10:29:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eKiZG-0007L1-Tf for pgsql-admin@lists.postgresql.org; Fri, 01 Dec 2017 10:29:14 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eKiZD-0001ii-UA for pgsql-admin@postgresql.org; Fri, 01 Dec 2017 10:29:14 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id E268120E2C; Fri, 1 Dec 2017 05:29:09 -0500 (EST) Received: from web4 ([10.202.2.214]) by compute7.internal (MEProxy); Fri, 01 Dec 2017 05:29:09 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hintbits.com; h= cc:content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=mesmtp; bh=hfaVJ8RP81I2JfnDkPmawRGtkm Qouh0YghF++QhPPPE=; b=pG81kaqhR2fea/c7ALHpLjqzNcWhqUgWxAcoBBN9c0 /8fN9Y8m5xcNVU4kSmCiGU6Zp0gHgPHi3vPkNR1OkWJG6/5u6PlfiAaeF8sNmR1n S8Xj6UOIvuCk1cc0ThWTx/q8j0FbD+ZpY2ldpPBGRXTsYCTxcvOBw6qsfr6vRsbZ g= DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=hfaVJ8 RP81I2JfnDkPmawRGtkmQouh0YghF++QhPPPE=; b=YYmvizyegXuObZ9yhASG/w HxotQwoBLg6g9KlmO3+Y2k6W77KRjujp3QxIdyjmR8ZguGSzbl0yq/QHd3Ian3ZF u3OGpCd7WK2QZdVjARDsvzIwLId5h+l3OYqYtQB8tDROeObym50r1W0VtHm+yi6e 4yITSevcirXy7maRNafl3xxPfGbRd5bBCAQqrMiPhtunNMrP48+lDqTh5sfObTeK R5QoTP9IWbNyXnvNipAPV6KD9JVSLdPX9CmzYIZ0qWRD+yQQjvEif1gASvJdIGje U0oummd/2F1QnATau7QD+3e1SZRjo+U0KZw7UCUYROSipLHJnM595DkhX9eCcXiw == X-ME-Sender: Received: by mailuser.nyi.internal (Postfix, from userid 99) id B4AFDBA797; Fri, 1 Dec 2017 05:29:09 -0500 (EST) Message-Id: <1512124149.1351359.1190486768.2A61F161@webmail.messagingengine.com> From: Alex Kliukin To: Debraj Manna , Magnus Hagander Cc: "pgsql-admin" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: multipart/alternative; boundary="_----------=_151212414913513590" X-Mailer: MessagingEngine.com Webmail Interface - ajax-a169161c In-Reply-To: <1512123472.1347799.1190472760.463DC314@webmail.messagingengine.com> Date: Fri, 01 Dec 2017 11:29:09 +0100 Subject: Re: [ADMIN] Upgrading postgres to 10 running with patroni References: <1512123472.1347799.1190472760.463DC314@webmail.messagingengine.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --_----------=_151212414913513590 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="utf-8" On Fri, Dec 1, 2017, at 11:17, Alex Kliukin wrote: > Hello, > > > The last step is definitely wrong. You should not copy > postmaster.opts, postgresql.base.conf and postgresql.conf. Instead, > you should configure the postgresql.conf in the PostgreSQL 10 data > directory to match the parameters of your old cluster. Copying > pg_hba.conf seems alright, since the one from 9.5 is compatible > with 10. Correction: since your configuration files are clearly not in the data directory, but in /etc/... you should edit them (and copy pg_hba.conf) there, not to the data directory. Sincerely, Alex --_----------=_151212414913513590 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset="utf-8"



On Fri, Dec 1, 2017, at 11:17, Alex Kliukin wrote:
Hello,


The last step is definitely wrong. You should not copy postmaster.opts, postgresql.base.conf and postgresql.conf. Instead, you should configure the postgresql.conf in the PostgreSQL 10 data directory to match the parameters of your old cluster. Copying pg_hba.conf seems alright, since the one from 9.5 is compatible with 10.

Correction: since your configuration files are clearly not in the data directory, but in /etc/... you should edit them (and copy pg_hba.conf) there, not to the data directory.

Sincerely,
Alex

--_----------=_151212414913513590--