If you are unable to install PostgreSQL on your own device, the resources for this workshop are available through a virtual Windows server hosted on Amazon Web Services.
An Amazon Machine Image (AMI) is available for you to use that will provide a Windows-based environment pre-configured for this workshop.
2022 Workshop
When launching a new instance, search for the public AMI ami-014cbf8e4109cef5c.
- Windows Server 2022
- PostgreSQL 14
- PostGIS 3.2
- QGIS 3.22
- pgAdmin 4 v6

After the instance has finished booting, you can connect through RDP using the following credentials:
- Username: Administrator
- Password: SQLworkshop2022
It is strongly suggested that you change this password if you intend to use this for an extended period of time.
Newer versions of pgAdmin require a password for storing preferences. Both the pgAdmin password and the postgres database account are set to “workshop” for convenience.
For more information on using servers on Amazon Web Services: https://aws.amazon.com/ec2/getting-started/