1

I am copying tables using ogr2ogr from Oracle to PostGIS. When I run try to load these I get,

ERROR 1: ERROR: permission denied for relation spatial_ref_sys when copying <table>@AWS
0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.