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 1kSztI-0001Qo-EP for pgsql-admin@arkaria.postgresql.org; Thu, 15 Oct 2020 09:49:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kSztH-0006ZC-Dc for pgsql-admin@arkaria.postgresql.org; Thu, 15 Oct 2020 09:49:43 +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 1kSztH-0006RM-3m for pgsql-admin@lists.postgresql.org; Thu, 15 Oct 2020 09:49:43 +0000 Received: from mout.gmx.net ([212.227.15.15]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kSztD-0007W9-Lm for pgsql-admin@lists.postgresql.org; Thu, 15 Oct 2020 09:49:42 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1602755377; bh=CPm+QItVtxnSSVfpBSmP5COwHyXauutobmdoJtubM94=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=R9+kqqgzjLVOiiHG9bLLiCihWmC+WBTriOu0FGVHXJ9HeWr1O4xYn1ASZJFHt4ZB4 emKUiH1Sweh2AHAdDu/3g+38sVJfKcV7wTDOI+dOfRD3gr2l+GmWu26SroLXrHEmqU PqesvecIYf9hdYXc0K1DM4ud/lGFSQmMtkH+2lNg= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [10.1.32.151] ([185.40.248.10]) by mail.gmx.com (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1N6bk4-1kOGVC3tc6-0180aL for ; Thu, 15 Oct 2020 11:49:37 +0200 Subject: Re: Regarding query on the postgresql upgrade To: pgsql-admin@lists.postgresql.org References: From: Thomas Kellerer Message-ID: <8148c916-87ea-e36c-763e-ad7ed9311e34@gmx.net> Date: Thu, 15 Oct 2020 11:49:36 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:2Ymv/2XcxpQ1RGHxvJZcshpZgQNVwocXecSY4ohYOoGIWaHGAzH 3V5AF5RQA6C2knCoCuFZTU39dOoXA1h62JES3ifM2FjtBYPz/x8MesqmN/hAoH9sdsTumDF 2sxSqen8c1bWBH4vj1xEX7LfnJvrx4Ne7/sEi+0qVD1SwadNyLmMDy/co+dLpnaaHKO4MW7 0UAigmDV++2NBYICb6xwA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:7u7vTn9iOWg=:RI/f5tR9SNDbLxN4YEyVuN ZK3Ip4Fk+Cn82EJhOwqogW5hyUpu0LEgBX0cIvH7P9HrXUEhiwYaDJE8FC0dcNl1RNxDC5Swx InO4ZZjBAiKHAsosmBu2sXH6ZCnWg3wORWouqWNzttG+8g5Oii0dxZbw/woEmXeWN+lyR3bdv RaImrvLl5roWw6zNQuGnptGTnM2+g/04Mgo7AAqQDCeu/G2k1hyKxwFlujHNjo3c0Wu3ojcm9 RYhlmQF1HlZOy3jYu1bS8m4tGsJvZ0NC67hJdcmmGNIveQ7LIn9yFpfeDRsKYgV49L3silKFr tewDDIKYMofKzhQkfPuDHhGOeiWGkNdamghcX9rWUCvaM6O3VNmSjXsN4QzgUQHZtzTe/uM2s Eu/jDWt0efQQ4DZje/IHcYIxpoT4H1v69QnP0RDnhuznTxby16GN1+oRE64UA1F++Bg4HP3q3 8PtxXdV0pFTWa1CwspODpyZjYQXM1+X9MmOhpeY1ZS+rf3nqtvuyf863sL35YxOz8RNgSNBdP AWZACkiH2LtfapNplUEQ5BiFDJq8kYVsjLI22xR/U1z5+7V/jThmUIhe4UOuKPZAMBIAgNzBW xPZeDrVHDp38FOuuv/JB5NJcA2uDE4a+SHuYgEtc8Ht7na6cHcyB3p/GtztOMzntIyouwXEvA R9CYskYZHqyRO8W4Ns3cIPoIlXOn4axDnUo95ZapYwdVUaoB4dwZOXb8iMQ++Y4i1xYMCESXV 7ptSIsPS4hedllrvRo+5O4alqC8WJo15zs6Df5fpp0ppEyNoYVrkL2k9yPqtnbpRe7XSmyemJ nVNqbd+Gah3rEPmB6k14WsJQ0SxcPlIa+tQDbmetMHrJ6iXCUeMpmuKuI+S7RBt3E6U6YOI1I AK/CLEK7dN3FApZ6g2xA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Ramesh Penuballi schrieb am 15.10.2020 um 10:27: > We are planning to upgrade the postgres version from 9.2.13 to > 9.4.25 by keeping the support version of Atlassian in mind. > > But to proceed the same in production, we have tried to run the > pgdump command to take the backup of all the databases and getting > the below error when we tried to take the dump of Eazybi database > which is not present on our stage environment. For a minor version upgrade you only need to install the new binaries and = restart the Postgres service. There is no need to use pg_dump/pg_restore in that case Thoma