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: | Raw Message | Whole Thread | 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 |