RDS: permission denied for relation spatial_ref_sys when copying
This error is a result of you not having access on that view. What you need to run to fix the permissions is

ALTER TABLE public.spatial_ref_sys OWNER TO rds_superuser;
GRANT SELECT, INSERT ON TABLE public.spatial_ref_sys TO public;


Found here on the AWS forums