i was able to get this to work for my aws aurora postgresql instance by running the following command first:

grant set on parameter log_statement to <master_user>;

then i was able to run the alter role command