will this upgrade strategy work?

Поиск
Список
Период
Сортировка
От Mark Steben
Тема will this upgrade strategy work?
Дата
Msg-id CADyzmyyB2HY8Kzjdb0OVQXkmQSxH4Rb+C+13uupM3k5RwdmOOA@mail.gmail.com
обсуждение исходный текст
Ответы Re: will this upgrade strategy work?  (Jerry Sievers <gsievers19@comcast.net>)
Список pgsql-admin
Дерево обсуждения
Good afternoon, team.

We wish to do a postgres upgrade from 9.4 to 9.6.  In order to minimize downtime we were thinking to do this:
  1. bring postgres down (9.4 is on 'diskset 1')
  2. do a physical copy of the data to 'diskset 2' (same phyxical server.
  3.  do an inplace pg_upgrade  to 9.6 on 'diskset 2'
  4.  Bring postgres up on 9.6 diskset 2
 This way we have 9.4 on diskset 1 to fall back on.

This would work much faster than the traditional dump restore.

Any comments welcome.  Thanks.


--
Mark Steben
 Database Administrator
@utoRevenue | Autobase 
  CRM division of Dominion Dealer Solutions 
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com





В списке pgsql-admin по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: User to get locked after three wrong login attempts.
Следующее
От: Jerry Sievers
Дата:
Сообщение: Re: will this upgrade strategy work?