Workshop Resources in the Cloud

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/