I am using the postgres built in replication with two slave nodes and a single master. On the master node (as well as the slaves) the hstore extension is installed. But whenever a query using hstore is ran on one of my slave nodes I get an error that type "hstore" does not exist.
So for example the query
SELECT product::hstore->make FROM products;
Would give me back all of the different product makes if it is ran on my master node. But as soon as I run it on the slave I get
ERROR: type "hstore" does not exist
I have used \dx on the slaves to make sure the hstore extension is installed, and it does show as being installed. Do you have any advice on how I can fix this error?