| From: | Tomonari Katsumata <t(dot)katsumata1122(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | more suitable messages for analyze on hot standby. |
| Date: | 2012-10-08 01:04:48 |
| Message-ID: | CAC55fYeaEE+3EtcYXj+WOmVOrheHHQZyGgA_AJ24v15P=0An+A@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.
========================================================
-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
| Attachment | Content-Type | Size |
|---|---|---|
| analyze_message_on_hotstandby.patch | application/octet-stream | 623 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2012-10-08 03:45:40 | Re: Rethinking placement of latch self-pipe initialization |
| Previous Message | Tom Lane | 2012-10-07 22:20:38 | Re: Improving psql \ds |