AWS RDS Demo

​

Step 1: Launching the AWS RDS Console

1. Log in to the AWS Console.
2. Search for “RDS” and navigate to the Amazon RDS dashboard.
3. Click Create database. This button might appear at the top of the page or in another prominent location.

​

Step 2: Choosing the Creation Method

• Click Create database.
• You will see two options: Standard Create and Easy Create.
  • Easy Create applies best practices automatically.
  • For this demo, select Standard Create to access all configuration settings.

​

Step 3: Configuring the Database Engine

• Select PostgreSQL or your preferred database engine.
• Choose the specific PostgreSQL version (the default version works fine for this demonstration).

• Production for high availability.
• Dev/Test for development or testing scenarios.
• Free Tier if eligible.

​

Step 4: Database Instance Configuration

• DB Instance Identifier: Provide a name (e.g., “my-first-db”).
• Master Username: The default for PostgreSQL is “postgres.”
• Password: Enter a secure password or let AWS generate one.

​

Instance and Storage Settings

• Select the EC2 instance type. The default suffices for a demo.
• Adjust storage settings:
  • Specify the storage type.
  • Allocate an appropriate amount (e.g., free tier typically requires at least 100 GB).
  • Enable storage autoscaling if desired.

​

Step 5: Establishing Connectivity

• Select a VPC. If unsure, choose the default VPC.
• Use the default subnet group if applicable.
• For demonstration purposes, enable public access to connect directly from your local machine.
• Create or select a security group; for this demo, create a new security group named “my DB security group.”
• Choose the preferred availability zone.

​

Step 6: Additional Configuration Settings

• Confirm that the database will use the default PostgreSQL port.
• You can modify authentication methods if needed, but for this demonstration, we’ll use the default password authentication.
• Other options such as monitoring, backup configurations, encryption, and RDS Proxy remain at their default values.

​

Step 7: Creating the Database

​

Step 8: Retrieving Connection Details

​

Connection Information

• Host: [Endpoint from RDS]
• Port: [Port number from RDS]
• Username: postgres
• Password: [Your password]
• Database: postgres (default database)

const knex = require("knex")({
  client: "pg",
  connection: {
    host: "my-first-db.cidipbxuwdg1.us-east-1.rds.amazonaws.com",
    port: 5432,
    user: "postgres",
    password: "password",
    database: "postgres",
  },
});

​

Step 9: Managing the PostgreSQL Database

• Database Name: my-app

(sqlite3.IntegrityError) UNIQUE constraint failed: database.id, database.server
[SQL: INSERT INTO "database" (id, schema_res, server) VALUES (?, ?)]
[parameters: (16402, '')]
(Background on this error at: http://sqlalche.me/e/13/gkpj)

​

Step 10: Modifying and Deleting the Database Instance

• Click Modify in the AWS Console to change settings such as the DB engine version, instance identifier, or password management options.

1. Click Delete.
2. Choose whether to retain snapshots and backups.
3. Acknowledge the deletion confirmation to permanently remove the instance.

​

Conclusion

​

Additional Resources

• AWS RDS Documentation
• PostgreSQL Documentation
• Knex.js Documentation