error message is not proper for analyze on standby.

From: Tomonari Katsumata <t(dot)katsumata1122(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: error message is not proper for analyze on standby.
Date: 2012-10-06 03:16:38
Message-ID: CAC55fYfbJa6JtxdAA4rEbSE6X4f1neJsvwd_N8Kcy=WKgeU-Ew@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

[before]
========================================================
-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 revised the message.

[after]
========================================================
-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 be
report actual thing.
please check it.

regards,

-------------
Tomonari Katsumata

Attachment Content-Type Size
analyze_message_on_hotstandby.patch application/octet-stream 623 bytes

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc Balmer 2012-10-06 09:15:49 Add the FET timetone abbreviation
Previous Message Michael Paquier 2012-10-06 02:57:24 Re: Support for REINDEX CONCURRENTLY