No stats after promoting standby?

Поиск
Список
Период
Сортировка
От Don Seiler
Тема No stats after promoting standby?
Дата
Msg-id CAHJZqBB=NPK5MmGk2xuP96yrvCY3U024n=BGkdrKsQe5BHvM9g@mail.gmail.com
обсуждение исходный текст
Ответы Re: No stats after promoting standby?  (Adrien Nayrat <adrien.nayrat@dalibo.com>)
Список pgsql-admin
I created a test standby that was recovering from our prod primary via restored WAL files. When I broke recovery and opened up that test standby, I saw that records in pg_stat_all_tables for tables that contain many millions of rows (and have for years) were saying a few hundred rows, with last_analyze and last_autoanalyze being null. I know this isn't the case for pg_stat_all_tables on prod. Do stats not automatically get preserved when a standby is promoted? Did something go wrong here or should I know/expect to have to manually gather DB stats after a failover (like we do with major upgrades)? This is PG 9.2.22 on CentOS. Don. -- Don Seiler www.seiler.us

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

Предыдущее
От: Jerry Sievers
Дата:
Сообщение: Re: Upgrading from 9.2 -> 9.6: ERROR with 'could not execute query: ERROR: permission denied for type my_type_name'
Следующее
От: Don Seiler
Дата:
Сообщение: Re: No stats after promoting standby?