Target server's authentication method must be changed

I’m have materialized views which I’m trying to refresh. When I run the command it errors with this
usoe_core=# REFRESH MATERIALIZED VIEW educator WITH DATA;
ERROR: password is required
DETAIL: Non-superuser cannot connect if the server does not request a password.
HINT: Target server’s authentication method must be changed.

I’ve tried setting the user to superuser but still fails with this. Note I have two other cluster running refresh materialized view which nosuperuser is set.
usoe_core=# alter user usoe_core with superuser;
ALTER ROLE
usoe_core=# set role usoe_core;
SET
usoe_core=# REFRESH MATERIALIZED VIEW educator WITH DATA;
ERROR: permission denied for relation educator
CONTEXT: Remote SQL command: SELECT teacher_id, back_id, core_area_id, grade_id, last_name, first_name, title, “position", address1, address2, city, state, zip, phone, email, identifier, w_phone, password, ed_submitted, home_link, uswest, descript, text_color, link_color, info_display, utap_mentor, utap_register_date, usoe_person_id, middle_name, suffix, username, ed_status_id, verification_key, email_changed, email_changed_from_verified, last_verified_email, invalid_email, display_email FROM public.educator
I did give the user usoe_core access privileges to the view
usoe_core=# \dp educator
Access privileges
Schema | Name | Type | Access privileges | Column privileges | Policies
--------+----------+-------------------+-----------------------------+-------------------+----------
public | educator | materialized view | usoe_core=arwdDxt/usoe_core |

I have two other clusters dev and prod which is working, but needed setup another cluster RC but can’t seem to get this one working

My clusters setup
2 pgpool hosts version 3.5.4
2 PostgreSQL hosts streaming replication version 9.5.5
Hosts Ubuntu 14.04.5

Thanks

Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
Wolf(at)uen(dot)org