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

Upgrading from Postgresql 9.1 to 10

2018-02-14 Thread pavan95
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 -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.ht