pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: RideNext <rntac.support@ridenext.co.in>
To: 'Greg Clough' <Greg.Clough@ihsmarkit.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: RE: Postgres takes more than 6 minutes to come up during host/standby switch over
Date: Fri, 6 Dec 2019 13:04:13 +0530
Message-ID: <007401d5ac07$908dd360$b1a97a20$@ridenext.co.in> (raw)
In-Reply-To: <MN2PR12MB3006DBAB5BEF6D2AB67B18C3EC5C0@MN2PR12MB3006.namprd12.prod.outlook.com>
References: <00ad01d5a5b8$83731320$8a593960$@ridenext.co.in>
	<MN2PR12MB3006E474F434D9824B20F145EC470@MN2PR12MB3006.namprd12.prod.outlook.com>
	<001201d5ab59$dfd3b3d0$9f7b1b70$@ridenext.co.in>
	<MN2PR12MB3006DBAB5BEF6D2AB67B18C3EC5C0@MN2PR12MB3006.namprd12.prod.outlook.com>

Hi Greg,

Thank you for the quick response and suggestions.

Thanks!
-----Original Message-----
From: Greg Clough <Greg.Clough@ihsmarkit.com> 
Sent: 05 December 2019 19:27
To: RideNext <rntac.support@ridenext.co.in>
Cc: pgsql-bugs@lists.postgresql.org
Subject: RE: Postgres takes more than 6 minutes to come up during
host/standby switch over

> So we would like to know if we upgrade to latest version will it be 
> smooth upgrade? Do you suspect any issues during upgrade and factors 
> to be considered? For example any of API name or format would change 
> in the latest version?

Major upgrades require testing and if you're jumping from 9.2 to 12, then
you're skipping ahead 7 major releases... so it will be a large undertaking
to validate your application, but you should start ASAP so you can move to
an environment that's secure.  If PostgreSQL is that old then I suspect your
OS is also quite old, and won't have fixes for major things like Heartbleed,
etc.

https://www.postgresql.org/docs/current/upgrading.html

If you're unsure on how to build new servers and then migrate the data, then
this is something I would suggest you need to hire a consultant to help
with.  In either case, this isn't a PostgreSQL bug so let's close this
thread, and if you want to post into a different forum then choose something
like pgsql-admin or pgsql-general:

https://www.postgresql.org/list/

Regards,
Greg.

________________________________

This e-mail, including accompanying communications and attachments, is
strictly confidential and only for the intended recipient. Any retention,
use or disclosure not expressly authorised by IHSMarkit is prohibited. This
email is subject to all waivers and other terms at the following link:
https://ihsmarkit.com/Legal/EmailDisclaimer.html

Please visit www.ihsmarkit.com/about/contact-us.html for contact information
on our offices worldwide.






view thread (3+ messages)

Message-ID: <007401d5ac07$908dd360$b1a97a20$@ridenext.co.in>
Permalink:  ../007401d5ac07$908dd360$b1a97a20$@ridenext.co.in/
Also on:    postgresql.org/message-id/007401d5ac07$908dd360$b1a97a20$@ridenext.co.in

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-bugs@postgresql.org
  Cc: rntac.support@ridenext.co.in, Greg.Clough@ihsmarkit.com
  Subject: Re: Postgres takes more than 6 minutes to come up during host/standby switch over
  In-Reply-To: <007401d5ac07$908dd360$b1a97a20$@ridenext.co.in>
  References: <00ad01d5a5b8$83731320$8a593960$@ridenext.co.in> <MN2PR12MB3006E474F434D9824B20F145EC470@MN2PR12MB3006.namprd12.prod.outlook.com> <001201d5ab59$dfd3b3d0$9f7b1b70$@ridenext.co.in> <MN2PR12MB3006DBAB5BEF6D2AB67B18C3EC5C0@MN2PR12MB3006.namprd12.prod.outlook.com> <007401d5ac07$908dd360$b1a97a20$@ridenext.co.in>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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