Recently, I’ve used extensions pg_partman, pg_cron to archive old data. Yesterday I saw a new partition but I cannot access it. I’ve checked that partition’s table owner, and it belongs to _dodb. As I know _dodb is a superuser and I can only log in with doadmin. How can I drop that partition without logging in with _dodb?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.