Re: Upgrading from Postgresql 9.1 to 10

2018-02-15 Thread pavan95
Thankyou Michael -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: Upgrading from Postgresql 9.1 to 10

2018-02-15 Thread Michael Paquier
On Wed, Feb 14, 2018 at 07:47:55AM -0700, David G. Johnston wrote: > Zero downtime is only possible by standing up a hot-standby then failing > over to it. Same-server upgrade you can do via pg_upgrade but it does > involve downtime. There are lots of material and options online, including > the

Re: Upgrading from Postgresql 9.1 to 10

2018-02-14 Thread Melvin Davidson
On Wed, Feb 14, 2018 at 10:04 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > > > On Wednesday, February 14, 2018, David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Wednesday, February 14, 2018, pavan95 >> wrote: >> >>> Hi all, >>> >>> Is it possible to upgrade an exis

Re: Upgrading from Postgresql 9.1 to 10

2018-02-14 Thread Pavan Teja
Yeah David, Even I'm thinking the same Regards, Pavan On Feb 14, 2018 8:34 PM, "David G. Johnston" wrote: > > > On Wednesday, February 14, 2018, David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Wednesday, February 14, 2018, pavan95 >> wrote: >> >>> Hi all, >>> >>> Is it possib

Re: Upgrading from Postgresql 9.1 to 10

2018-02-14 Thread David G. Johnston
On Wednesday, February 14, 2018, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, February 14, 2018, pavan95 > wrote: > >> Hi all, >> >> Is it possible to upgrade an existing postgresql 9.1 production system to >> latest Postgres 10.0 version? >> >> The main requirement is t

Re: Upgrading from Postgresql 9.1 to 10

2018-02-14 Thread Pavan Teja
Thank you for your timely response 😊 On Feb 14, 2018 8:18 PM, "Melvin Davidson" wrote: > > > On Wed, Feb 14, 2018 at 9:42 AM, pavan95 > wrote: > >> Hi all, >> >> Is it possible to upgrade an existing postgresql 9.1 production system to >> latest Postgres 10.0 version? >> >> The main requirement

Re: Upgrading from Postgresql 9.1 to 10

2018-02-14 Thread Melvin Davidson
On Wed, Feb 14, 2018 at 9:42 AM, pavan95 wrote: > Hi all, > > Is it possible to upgrade an existing postgresql 9.1 production system to > latest Postgres 10.0 version? > > The main requirement is to get rid of downtime. Please help me out! > > Thanks in Advance. > > Regards, > Pavan > > > > -- >

Re: Upgrading from Postgresql 9.1 to 10

2018-02-14 Thread David G. Johnston
On Wednesday, February 14, 2018, pavan95 wrote: > Hi all, > > Is it possible to upgrade an existing postgresql 9.1 production system to > latest Postgres 10.0 version? > > The main requirement is to get rid of downtime. Please help me out! > Zero downtime is only possible by standing up a hot-st