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 1n2X0k-0000fB-27 for pgsql-admin@arkaria.postgresql.org; Wed, 29 Dec 2021 11:20:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n2X0h-0000QG-QO for pgsql-admin@arkaria.postgresql.org; Wed, 29 Dec 2021 11:20:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n2X0h-0000Q5-FC for pgsql-admin@lists.postgresql.org; Wed, 29 Dec 2021 11:20:47 +0000 Received: from mail49153.hm1315.locaweb.com.br ([201.76.49.153]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n2X0X-0005Eh-FM for pgsql-admin@lists.postgresql.org; Wed, 29 Dec 2021 11:20:45 +0000 Received: from mcbain0011.email.locaweb.com.br (189.126.112.14) by mail4950.hm1315.locaweb.com.br id hph28c2n8lg7 for ; Wed, 29 Dec 2021 08:10:21 -0300 (envelope-from ) Received: from dragonite0028.email.locaweb.com.br (unknown [10.31.120.17]) by mcbain0011.email.locaweb.com.br (Postfix) with ESMTP id 55222EC0A32; Wed, 29 Dec 2021 08:10:12 -0300 (-03) x-locaweb-id: 4yzFnsAuG-aoB8121rEtwqRsArWegKay809cGRThiUdolpoqI-3LeQTCj8FxzF6QTww8FLNbU6cF3KKaTK4hBOCwNVkqLfpD6g70eJjD4SstmhyhBw_km8s4Yrr-V8MSZk8AzouUhVO-6zBbzGjOU1ryhKTrgoN7cPMZwPGOdmm5bkpAR1sXehULSY5BIqlnwJ056NLHNIn4QVhON6cGB1veSBd8y8B8118Jppb9tI0= NmY3Mzc3NjE2YzY0NmYyZTYyNzI2NTY3NmU2ZjZjNjU3MzQwNzA2YzYxNmU2OTZlMmU2MzZmNmQyZTYyNzI= x-locaweb-id: 4yzFnsAuG-aoB8121rEtwqRsArWegKay809cGRThiUdolpoqI-3LeQTCj8FxzF6QTww8FLNbU6cF3KKaTK4hBOCwNVkqLfpD6g70eJjD4SstmhyhBw_km8s4Yrr-V8MSZk8AzouUhVO-6zBbzGjOU1ryhKTrgoN7cPMZwPGOdmm5bkpAR1sXehULSY5BIqlnwJ056NLHNIn4QVhON6cGB1veSBd8y8B8118Jppb9tI0= NmY3Mzc3NjE2YzY0NmYyZTYyNzI2NTY3NmU2ZjZjNjU3MzQwNzA2YzYxNmU2OTZlMmU2MzZmNmQyZTYyNzI= x-locaweb-id: 4yzFnsAuG-aoB8121rEtwqRsArWegKay809cGRThiUdolpoqI-3LeQTCj8FxzF6QTww8FLNbU6cF3KKaTK4hBOCwNVkqLfpD6g70eJjD4SstmhyhBw_km8s4Yrr-V8MSZk8AzouUhVO-6zBbzGjOU1ryhKTrgoN7cPMZwPGOdmm5bkpAR1sXehULSY5BIqlnwJ056NLHNIn4QVhON6cGB1veSBd8y8B8118Jppb9tI0= NmY3Mzc3NjE2YzY0NmYyZTYyNzI2NTY3NmU2ZjZjNjU3MzQwNzA2YzYxNmU2OTZlMmU2MzZmNmQyZTYyNzI= x-locaweb-id: 4yzFnsAuG-aoB8121rEtwqRsArWegKay809cGRThiUdolpoqI-3LeQTCj8FxzF6QTww8FLNbU6cF3KKaTK4hBOCwNVkqLfpD6g70eJjD4SstmhyhBw_km8s4Yrr-V8MSZk8AzouUhVO-6zBbzGjOU1ryhKTrgoN7cPMZwPGOdmm5bkpAR1sXehULSY5BIqlnwJ056NLHNIn4QVhON6cGB1veSBd8y8B8118Jppb9tI0= NmY3Mzc3NjE2YzY0NmYyZTYyNzI2NTY3NmU2ZjZjNjU3MzQwNzA2YzYxNmU2OTZlMmU2MzZmNmQyZTYyNzI= Received: from webmail-seguro.com.br (localhost [127.0.0.1]) (Authenticated sender: oswaldo.bregnoles@planin.com.br) by dragonite0028.email.locaweb.com.br (Postfix) with ESMTPA id F31AF22175D; Wed, 29 Dec 2021 08:10:10 -0300 (-03) MIME-Version: 1.0 Date: Wed, 29 Dec 2021 08:10:10 -0300 From: oswaldo.bregnoles@planin.com.br To: Ravi GH Cc: kaido vaikla , Tom Lane , Pgsql-admin Subject: Re: Pg upgrade from 10.x to 12.x recommendations In-Reply-To: <5678103F-59DC-437F-89B5-96C7DF91C8CF@gmail.com> References: <42AA8DD8-B4C7-4850-90DC-D7BE77BE1ED9@gmail.com> <1513791.1640626827@sss.pgh.pa.us> <5678103F-59DC-437F-89B5-96C7DF91C8CF@gmail.com> Message-ID: <0821973507f759c249b09643e7f70413@planin.com.br> X-Sender: oswaldo.bregnoles@planin.com.br User-Agent: Roundcube Webmail/1.4.11 Content-Type: multipart/alternative; boundary="=_bfbc2fed355f616059531cc7810dfc64" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=_bfbc2fed355f616059531cc7810dfc64 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=UTF-8 Bom dia, Por gentileza alguém poderia me dizer como resolvo um problema de Cluster? Estou migrando o postgresql utilizando Pg upgrade da versão 8.3 para 9.3, e está me apresentando esse erro? #mapped win32 error code 2 to 2 Old and new pg_controldata date/time storage types do not match. #You will need to rebuild the new server with configure option --disable-integer-datetimes or get server binaries built with those aguardo algum comentário e ajuda sobre esse caso. obrigado! --- Att Oswaldo Planin Sistemas Em 28/12/2021 11:21, Ravi GH escreveu: > Thanks a lot for the URLs shared, I could easily compare my postgresql.conf file changes and identified features like restart_after_crash are very helpful and also CVE fixes. > The provided links helped very much. > > On 28-Dec-2021, at 1:06 PM, kaido vaikla wrote: > > Hi, > A few helpful url's > https://why-upgrade.depesz.com/show?from=10&to=12.9 > https://pgconfig.rustprooflabs.com/param/change/10/12 > and if You don't use an exp-imp for pg upgrade then for indexes > https://blog.crunchydata.com/blog/just-upgrade-how-postgresql-12-can-improve-your-performance > br > Kaido > > On Mon, 27 Dec 2021 at 19:40, Tom Lane wrote: Ravi GH writes: >> What are the recommended / major features/security fixes added to PG 12.x which makes upgrade to PG 12.x is critical now. > > Reading the release notes would help you decide. > > https://www.postgresql.org/docs/release/ > > regards, tom lane --=_bfbc2fed355f616059531cc7810dfc64 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=UTF-8

Bom dia,
Por gentileza alguém poderia me dizer como resolvo = um problema de Cluster?

Estou migrando o postgresql utilizando Pg upgrade da versão 8.3 p= ara 9.3, e está me apresentando esse erro?

#mapped win32 error code 2 to 2

Old and new pg_controldata date/time storage types do not match.


#You will need to rebuild the new server with configure option

--disable-integer-datetimes or get server binaries built with those

aguardo algum comentário e ajuda sobre esse caso.

obrigado!

---

Att

Oswaldo
Planin Sistemas


Em 28/12/2021 11:21, Ravi GH escreveu:

Thanks a lot for the URLs shared, I could easily compare my postgresql= =2Econf file changes and identified features like restart_after_crash are v= ery helpful and also CVE fixes.
The provided links helped very much.
 
 

On 28-Dec-2021, at 1:06 PM, kaido vaikla <kaido.vaikla@gmail.com> wrote:

On Mon, 27 Dec 2021 at 19:40, Tom Lan= e <tgl@sss.pgh.pa.us> wrote:=
Ravi GH <mails2ravi@gmail.com> writes:
> Wha= t are the recommended / major features/security fixes added to PG 12.x whic= h makes  upgrade to PG 12.x is critical now.

Reading the = release notes would help you decide.

h= ttps://www.postgresql.org/docs/release/

    &nbs= p;                   regards, = tom lane

--=_bfbc2fed355f616059531cc7810dfc64--