This post is mostly directed to anyone that's taking my Database Foundations: Intro to Databases course on LinkedIn Learning.
Hi Everyone!
There’s been an uptick in the number of people having issues with PostgreSQL and Azure Data Studio lately. Version 15 of Postgres made some internal changes that made it incompatible with the Azure Data Studio Postgres extension, and Microsoft seems to have abandoned the project and is no longer making updates. The transition to Apple Silicon macs has also thrown in some wrinkles if you’re on that platform. Here’s a couple of things to try if you’re having issues:
- Use the older 14.7 version of postgres instead. In the
docker runcommand, putpostgres:14.7at the end instead ofpostgres:latest. This option continues to work for me on an M1 Mac. - Double check all of your connection parameters in Azure Data Studio. Make sure you’re using the Postgres extension, ‘localhost’ for the server, the ‘postgres’ user with the password you set when creating the Docker container, and the port 5401 on the Advanced page. The correct port is the first number used in the
-p 5401:5432portion of your docker run command - Restart Azure Data Studio. Sometimes a hiccup occurs in the Postgres extension that is flushed out after the program is shut down and restarted.
- If you still can’t get the connection to work, you can opt to proceed with the course with just the SQL Server database connection.
- Alternatively, install the PostgreSQL native GUI pgAdmin and use that for the Postgres portion of the course. It works similarly to Azure Data Studio, and you can download it at pgAdmin.org. Tables will be found under the Schemas/Public folder in pgAdmin, and there are some other minor differences. Feel free to reach out if you go this route and have any questions.
My apologies for any difficulties. It’s a bit of a moving target sometimes when software changes after a course is released, and I’ll see what I can do to update the content to streamline some of these challenges.