Обсуждение: more suitable messages for analyze on hot standby.

Поиск
Список
Период
Сортировка

more suitable messages for analyze on hot standby.

От
Tomonari Katsumata
Дата:
Hi,

I work with streaming replication and hot standby.
And I noticed that error message is not proper when I issue
ANALYZE command to standby.

========================================================
-bash-3.2$ psql -c "analyze"
ERROR:  cannot execute VACUUM during recovery
STATEMENT:  analyze
ERROR:  cannot execute VACUUM during recovery
========================================================

ANALYZE command is not VACUUM command.
I attached a patch revising the message.

========================================================
-bash-3.2$ psql -c "analyze"
ERROR:  cannot execute ANALYZE during recovery
STATEMENT:  analyze
ERROR:  cannot execute ANALYZE during recovery
========================================================

This is not big problem, but error message should report
actual thing. please check it.

regards,

-------------
Tomonari Katsumata
Вложения

Re: more suitable messages for analyze on hot standby.

От
Heikki Linnakangas
Дата:
On 08.10.2012 04:04, Tomonari Katsumata wrote:
> I work with streaming replication and hot standby.
> And I noticed that error message is not proper when I issue
> ANALYZE command to standby.
>
> ...>
> This is not big problem, but error message should report
> actual thing. please check it.

Thanks, committed with some stylistic changes.

- Heikki