I have a postgres instance running on version 15 in centos7.I have created a custom database and revoked all public privileges from that database.
Would be better to provide the actual psql script of what you’ve done instead of writing it out in prose. That way the question of whether you’ve done something wrong or not is directly and accurately answerable
David J.