Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h60HL-0000Vb-NA for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Mar 2019 21:58:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h60HK-0007Px-7f for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Mar 2019 21:58:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h60HJ-0007Pq-Ub for pgsql-bugs@lists.postgresql.org; Mon, 18 Mar 2019 21:58:42 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h60HH-0000kY-Jd for pgsql-bugs@lists.postgresql.org; Mon, 18 Mar 2019 21:58:40 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x2ILwb4S005835; Mon, 18 Mar 2019 17:58:37 -0400 From: Tom Lane To: Tomasz Szypowski cc: pgsql-bugs@lists.postgresql.org Subject: Re: pg_upgrade In-reply-to: References: <2267.1552919581@sss.pgh.pa.us> Comments: In-reply-to Tomasz Szypowski message dated "Mon, 18 Mar 2019 21:55:21 +0100" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <5833.1552946317.1@sss.pgh.pa.us> Date: Mon, 18 Mar 2019 17:58:37 -0400 Message-ID: <5834.1552946317@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Tomasz Szypowski writes: > thanks for the response. After initdb tempate1 has datistemplate as true Right, initdb leaves it set that way, but I'm guessing that it's not like that in the database you're trying to pg_upgrade. regards, tom lane