Logging my journey through Practical SQL 2nd Edition

I picked up Practical SQL (2nd Edition), and my thinking here is maybe having breadcrumbs of where I’ve run into issues and hopefully found solutions, might be worth having around in the future and potentially be helpful for others on the journey.

Not the biggest bump in the road but…

After installing Pgadmin, and opening it up as the book said, I was not prompted to create a master password. Now, not the biggest problem one might think since I can probably just find it in the settings somewhere. But I’ve got to say, and I’m not too surprised here, there’s a lot going on with menus and submenus. So this should be fun to sort out. The other option is to just roll along and either I may get prompted to set it when I try to complete some action as I move along with the material.

Solution

Well then…

pgAdmin 4 uses the operating system password store by default to store the saved server passwords in desktop mode from version 7.2 onwards and Master password will not be required.

via. https://www.pgadmin.org/docs/pgadmin4/latest/master_password.html