Create an AWS RDS PostgreSQL® instance

  1. Select PostgreSQL® version 16:
    Figure 1. Select PostgreSQL® version
  2. For our demo we will use a single instance (clusters are expensive to run!)
  3. Set up the credentials.
    Figure 2. Setup Credentials
    Note:
    Remember to use more secure credentials than shown in this demo and unlike this example, avoid using '-' as this can cause problems!

  4. The default configuration is more than sufficient for our demo as we do not expect much data to be written.

    For real deployment, you should choose more suitable values instead.
    Figure 3. Default configuration

  5. Connectivity

    Choose your own VPC and use the security group we created before (in this case it's called default, but yours might be called differently) and do not forget to enable public access.
    Figure 4. Connectivity
    The default certificate authority selected by AWS may not be the best, as some warnings occur when using it.
    Figure 5. Default Certificate Authority
    It might be better to directly use the solution suggested in the security warnings.
    Figure 6. RDS Certificate Authority
  6. Select the password authentication
    Figure 7. Password authentication
  7. Once the database is created, you’ll see an endpoint and a port:
    Figure 8. Summary

  8. Check whether the connection to the database is working by calling up a command line:

    psql -p <port> -h <host> -U <user>  
e.g.:  
psql -p 5432 -h rds-test.cjqhuqrjxwbk.eu-central-1.rds.amazonaws.com -U postgres

    Or use UI-based applications such as PgAdmin. Assuming you had no problems and can connect to your database instance, you have a running RDS PostgreSQL® database! In the next chapter we will learn how to populate the data and connect WinCC OA.