New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Reading HSTORE columns from slave Postgres 9.3 Server
agoldenberg
Member, Host Rep
in Help
So I've got HSTORE up and running on my Master server, however on my two slaves whenever the application tries to query the slaves I get this error:
Message: SQLSTATE[42704]: Undefined object: 7 ERROR: type "hstore" does not exist
I've checked the PG slaves using \DX and both are showing HSTORE is installed, however whenever the app tries to read it gets the error above. HELP PLEASE