Re: [GENERAL] How to upgrade PostgreSQL minor version?

2017-04-26 Thread Adrian Klaver
On 04/26/2017 06:56 AM, Ron Ben wrote: Hi, What are standbys? Standbys are the standby servers when you are using replication: https://www.postgresql.org/docs/9.3/static/high-availability.html I am guessing you are not using replication. My question was more of how to actualy do the

Re: [GENERAL] How to upgrade PostgreSQL minor version?

2017-04-26 Thread David G. Johnston
​The convention on these lists is to bottom-post. On Wed, Apr 26, 2017 at 6:56 AM, Ron Ben wrote: > Hi, > > What are standbys? > High-level: ​a standby is a second server, running the same version of PostgreSQL, the reads the real-time backup/WAL data from the primary

Re: [GENERAL] How to upgrade PostgreSQL minor version?

2017-04-26 Thread Ron Ben

Re: [GENERAL] How to upgrade PostgreSQL minor version?

2017-04-26 Thread Adrian Klaver
On 04/26/2017 03:36 AM, Ron Ben wrote: Hi :) I do have a test enviroment and I will test eveything there first but I had cases where eveything worked on test but on production I had difficultes. It's rare but can happen. Problems with upgrading PostgreSQL isn't like upgrading a package which

Re: [GENERAL] How to upgrade PostgreSQL minor version?

2017-04-26 Thread Ron Ben
Hi :) I do have a test enviroment and I will test eveything there first but I had cases where eveything worked on test but on production I had difficultes. It's rare but can happen. Problems with upgrading PostgreSQL isn't like upgrading a package which effects few functions. Since the

Re: [GENERAL] How to upgrade PostgreSQL minor version?

2017-04-26 Thread Sameer Kumar
On Wed, Apr 26, 2017 at 4:41 PM Ron Ben wrote: > I'm runing PostgreSQL 9.3.3 and I want to upgrade it to the latest 9.3 > version > The documontation does not specify what needs to be done other than "just > install the executables". > This is wierd as for example 9.3.5

[GENERAL] How to upgrade PostgreSQL minor version?

2017-04-26 Thread Ron Ben
I'm runing PostgreSQL 9.3.3 and I want to upgrade it to the latest 9.3 version The documontation does not specify what needs to be done other than "just install the executables". This is wierd as for example 9.3.5 release notes request to run a specifc query to  check for pg_multixact files left.