I’m trying to declare CURSOR on table with ~9M records

DECLARE "name" NO SCROLL CURSOR WITH HOLD FOR SELECT ....

and it fails with error: terminating connection due to administrator command. No logs, nothing.

DigitalOcean, any suggestions?