I keep losing track of this wondering where it went. You have to access it at the database level. Adding this post to remind me for later. This came in very handy when my home internet went down and I couldn’t auth on my phone…
Month: January 2025
Let me start by saying that there are some issues with these scripts. They aren’t deal breakers, but I will loop back after my migrations to fix them—hopefully. You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles are granted to…
It’s easy to do with this query. That’s all I have to say on this topic for now.
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also using the Azure migration tool. I had to ultimately do a combo of those because of the limitations of the Azure migration tool. Getting your roles in place The Azure migration…