Postgres Pro
Downloads
Home   >   mailing lists

more suitable messages for analyze on hot standby. - Mailing list pgsql-hackers

From Tomonari Katsumata
Subject more suitable messages for analyze on hot standby.
Date
Msg-id CAC55fYeaEE+3EtcYXj+WOmVOrheHHQZyGgA_AJ24v15P=0An+A@mail.gmail.com
Whole thread Raw
Responses Re: more suitable messages for analyze on hot standby.  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Bugs in CREATE/DROP INDEX CONCURRENTLY
Next
From: Amit Kapila
Date:
Subject: Re: Rethinking placement of latch self-pipe initialization