pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPg upgrade from 10.x to 12.x recommendations
6+ messages / 5 participants
[nested] [flat]
* Pg upgrade from 10.x to 12.x recommendations
@ 2021-12-27 17:02 Ravi GH <mails2ravi@gmail.com>
2021-12-27 17:08 ` Re: Pg upgrade from 10.x to 12.x recommendations Kenneth Marshall <ktm@rice.edu>
2021-12-27 17:40 ` Re: Pg upgrade from 10.x to 12.x recommendations Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 6+ messages in thread
From: Ravi GH @ 2021-12-27 17:02 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org; +Cc: Ravi GH <Mails2ravi@gmail.com>
Hello PG Team,
We have tested Postgres db upgrade from 10.x to 12.x in stage instance(all works) however we want to prioritise the upgrade along with other projects and we would like to know
what is the main features / bugs fixes done in 12.8 which is very critical so that it will help us to take business decision to upgrade at the earliest.
What are the recommended / major features/security fixes added to PG 12.x which makes upgrade to PG 12.x is critical now.
Thanks & Regards,
Ravi
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Pg upgrade from 10.x to 12.x recommendations
2021-12-27 17:02 Pg upgrade from 10.x to 12.x recommendations Ravi GH <mails2ravi@gmail.com>
@ 2021-12-27 17:08 ` Kenneth Marshall <ktm@rice.edu>
1 sibling, 0 replies; 6+ messages in thread
From: Kenneth Marshall @ 2021-12-27 17:08 UTC (permalink / raw)
To: Ravi GH <mails2ravi@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
> Hello PG Team,
>
> We have tested Postgres db upgrade from 10.x to 12.x in stage instance(all works) however we want to prioritise the upgrade along with other projects and we would like to know
> what is the main features / bugs fixes done in 12.8 which is very critical so that it will help us to take business decision to upgrade at the earliest.
>
> What are the recommended / major features/security fixes added to PG 12.x which makes upgrade to PG 12.x is critical now.
>
>
> Thanks & Regards,
> Ravi
Hi Ravi,
Probably the biggest reason will be that the final release of version 10
will be November 10, 2022, less than one year away.
Regards,
Ken
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Pg upgrade from 10.x to 12.x recommendations
2021-12-27 17:02 Pg upgrade from 10.x to 12.x recommendations Ravi GH <mails2ravi@gmail.com>
@ 2021-12-27 17:40 ` Tom Lane <tgl@sss.pgh.pa.us>
2021-12-28 07:36 ` Re: Pg upgrade from 10.x to 12.x recommendations kaido vaikla <kaido.vaikla@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Tom Lane @ 2021-12-27 17:40 UTC (permalink / raw)
To: Ravi GH <mails2ravi@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Ravi GH <mails2ravi@gmail.com> 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Pg upgrade from 10.x to 12.x recommendations
2021-12-27 17:02 Pg upgrade from 10.x to 12.x recommendations Ravi GH <mails2ravi@gmail.com>
2021-12-27 17:40 ` Re: Pg upgrade from 10.x to 12.x recommendations Tom Lane <tgl@sss.pgh.pa.us>
@ 2021-12-28 07:36 ` kaido vaikla <kaido.vaikla@gmail.com>
2021-12-28 14:21 ` Re: Pg upgrade from 10.x to 12.x recommendations Ravi GH <mails2ravi@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: kaido vaikla @ 2021-12-28 07:36 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Ravi GH <mails2ravi@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 <tgl@sss.pgh.pa.us> wrote:
> Ravi GH <mails2ravi@gmail.com> 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
>
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Pg upgrade from 10.x to 12.x recommendations
2021-12-27 17:02 Pg upgrade from 10.x to 12.x recommendations Ravi GH <mails2ravi@gmail.com>
2021-12-27 17:40 ` Re: Pg upgrade from 10.x to 12.x recommendations Tom Lane <tgl@sss.pgh.pa.us>
2021-12-28 07:36 ` Re: Pg upgrade from 10.x to 12.x recommendations kaido vaikla <kaido.vaikla@gmail.com>
@ 2021-12-28 14:21 ` Ravi GH <mails2ravi@gmail.com>
2021-12-29 11:10 ` Re: Pg upgrade from 10.x to 12.x recommendations oswaldo.bregnoles@planin.com.br
0 siblings, 1 reply; 6+ messages in thread
From: Ravi GH @ 2021-12-28 14:21 UTC (permalink / raw)
To: kaido vaikla <kaido.vaikla@gmail.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 <kaido.vaikla@gmail.com> wrote:
>
> Hi,
> A few helpful url's
> https://why-upgrade.depesz.com/show?from=10&to=12.9 <https://why-upgrade.depesz.com/show?from=10&to=12.9;
> https://pgconfig.rustprooflabs.com/param/change/10/12 <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 <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 <tgl@sss.pgh.pa.us <mailto:tgl@sss.pgh.pa.us>> wrote:
> Ravi GH <mails2ravi@gmail.com <mailto:mails2ravi@gmail.com>> 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/ <https://www.postgresql.org/docs/release/;
>
> regards, tom lane
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Pg upgrade from 10.x to 12.x recommendations
2021-12-27 17:02 Pg upgrade from 10.x to 12.x recommendations Ravi GH <mails2ravi@gmail.com>
2021-12-27 17:40 ` Re: Pg upgrade from 10.x to 12.x recommendations Tom Lane <tgl@sss.pgh.pa.us>
2021-12-28 07:36 ` Re: Pg upgrade from 10.x to 12.x recommendations kaido vaikla <kaido.vaikla@gmail.com>
2021-12-28 14:21 ` Re: Pg upgrade from 10.x to 12.x recommendations Ravi GH <mails2ravi@gmail.com>
@ 2021-12-29 11:10 ` oswaldo.bregnoles@planin.com.br
0 siblings, 0 replies; 6+ messages in thread
From: oswaldo.bregnoles@planin.com.br @ 2021-12-29 11:10 UTC (permalink / raw)
To: Ravi GH <mails2ravi@gmail.com>; +Cc: kaido vaikla <kaido.vaikla@gmail.com>; Tom Lane <tgl@sss.pgh.pa.us>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 <kaido.vaikla@gmail.com> 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 <tgl@sss.pgh.pa.us> wrote: Ravi GH <mails2ravi@gmail.com> 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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2021-12-29 11:10 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-12-27 17:02 Pg upgrade from 10.x to 12.x recommendations Ravi GH <mails2ravi@gmail.com>
2021-12-27 17:08 ` Kenneth Marshall <ktm@rice.edu>
2021-12-27 17:40 ` Tom Lane <tgl@sss.pgh.pa.us>
2021-12-28 07:36 ` kaido vaikla <kaido.vaikla@gmail.com>
2021-12-28 14:21 ` Ravi GH <mails2ravi@gmail.com>
2021-12-29 11:10 ` oswaldo.bregnoles@planin.com.br
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox