Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ped9j-0003J2-Nr for pgsql-general@arkaria.postgresql.org; Tue, 21 Mar 2023 14:40:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ped9i-0003Hr-7p for pgsql-general@arkaria.postgresql.org; Tue, 21 Mar 2023 14:40:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ped9g-0003HU-MN for pgsql-general@lists.postgresql.org; Tue, 21 Mar 2023 14:40:05 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ped9b-0007Gg-4F for pgsql-general@postgresql.org; Tue, 21 Mar 2023 14:40:03 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id C81305C0130; Tue, 21 Mar 2023 10:39:57 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Tue, 21 Mar 2023 10:39:57 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to; s=fm1; t= 1679409597; x=1679495997; bh=8kNn1vyRX55mjxt8otvRS8qRvkjiHG2bKlr /8Ozj/QI=; b=Spt+K0yit2DbmJqxMsBLhhd3jYzE/mc6Avps9+2BrblmyWwrb2r KgQHtl8mzkXaMv0FV0KKkjIavSsMKjFvD+uGgd6GQ2JHq4WPe3VetSe+jlTwramr uMEiEZMGGG+YgeaQaGqRVHSKOL90RWobOpTm2y6FwdkHiLsDLFJkkOZwxujMT2P8 4kH8OC6Cn3y1MIZoL8RQ9mGm0dKBL6RAs+JEkKzWngVkQY2qbG3t/kQ8o3ewKmfT KrNhCyKL5TFAwCWeD+M2wtFMM0Zf5EA53ZPljxkOVo7z40v955gmLs/LcliC9ain 9H44DR3mJ0ouVqgCOMV8hlftszX31QjvG1w== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1679409597; x=1679495997; bh=8kNn1vyRX55mjxt8otvRS8qRvkjiHG2bKlr /8Ozj/QI=; b=sUOMA2UXS/yo6Q9PLU5RHs+QL/sTdWWi+i3e1Wb72JoIZHyz/DA 06bBu0dBFuZl/ZFykYKQYbSziTLqKKF3H3khmy6gWodTYV1/XBmiLfJ9ClgtVlim yMyujZHNycz2Ql4c42imK2yPyREZ4j971E0UVpuqZ9GqbRHargLnn9ki5lFVdJX6 5IUpr/E87JeEjpq/1rQPt0LZIbK0CGLkEmFe/a3y0HulN4afh7Jj7c16/P3CgpNX 9+1PuApgJ08tcg72eAZ/g/OddPwpTnBtAwiNBerA0diZzBCaxyRNOcXnv1cWXxCE ibEG5TSy1OKCiiL8fEiWtnEaZXmbJm/FOTA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrvdegtddgieeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtkeertddtfeejnecuhfhrohhmpeetughr ihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtg homheqnecuggftrfgrthhtvghrnhephedugfethfettdehieevteeukedtjedvhfevkefg udefgeevteduvdeuvdeggeegnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpe hmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 21 Mar 2023 10:39:56 -0400 (EDT) Message-ID: <1312ebb1-e23e-642a-0548-a8d5283ed6e4@aklaver.com> Date: Tue, 21 Mar 2023 07:39:56 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.9.0 Subject: Re: Getting error while upgrading postgres from version 12 to 13 To: shashidhar Reddy , abdulsayeed24@gmail.com Cc: pgsql-general , "David G. Johnston" References: <1679290629.219876696@f41.my.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/21/23 03:29, shashidhar Reddy wrote: > Actually I was using the below command to check the compatibility, it > worked without any issue with 12.6 but it is not working with 1version 2.14 > time /usr/lib/postgresql/13/bin/pg_upgrade --old-bindir > /usr/lib/postgresql/12/bin --new-bindir /usr/lib/postgresql/13/bin > --old-datadir /usr/pgdata/pg_data --new-datadir /usr/pgdata/pg_data2 > --link --check > > I have used a different directory for postgres13 from postgres 12. The issue is not that they are the same directory it is: FATAL: database files are incompatible with server DETAIL: The data directory was initialized by PostgreSQL version 13 , which is not compatible with this version 12.14 (Ubuntu 12.14-1.pgdg18.04+1) Check the value that is the PG_VERSION file in each data directory. It should be 12 in /usr/pgdata/pg_data and 13 in /usr/pgdata/pg_data2. > > On Mon, Mar 20, 2023 at 11:07 AM > wrote: > > Hello, > > As per error it seems you have initiated source data with PG13 > binaries. > > Could you please connect to both source and target psql and share > out of select versions(); > > Also share pg_upgrade complete command which you are using. > > > > Regards, > Abdul Sayeed > > > > Sent from myMail for iOS > > > Sunday, 19 March 2023 at 11:29 AM +0530 from > david.g.johnston@gmail.com > >: > > On Sat, Mar 18, 2023 at 7:27PM shashidhar Reddy > > wrote: > > Can someone please help me with this? > > > > You haven't given others enough information to help you. > Present to the fullest extent possible your current environment > and the commands you are running.  Showing that psql itself > works on both running clusters would be a good start.  Show > inputs, not just outputs those inputs creates. > > David J. > > > > -- > Shashidhar -- Adrian Klaver adrian.klaver@aklaver.com