Since I am trying to restore, I believe the user should have pg_write_system_files role, hence trying to grant it.
Restoring a backup does not require the client connection to access the server’s filesystem - all data is passed over the client connection.
David J.
