Skip to content

Instantly share code, notes, and snippets.

@chefThomas

chefThomas/dbeav.md

Last active April 30, 2021 19:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save chefThomas/4888dd7f6a7d7896ab9b4f0426e10e30 to your computer and use it in GitHub Desktop.
Save chefThomas/4888dd7f6a7d7896ab9b4f0426e10e30 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dbeav.md

Demo: Configuring and Connecting to an Amazon RDS from DBeaver

Login to your AWS account first. If you haven't created an AWS account yet, go ahead and create one here, and then follow the steps below:

  1. Upon logging in, navigate to the RDS Dashboard by searching RDS and clicking the first result.

  2. Select the following configurations:

    • Create database
    • Standard create
    • Engine Options: PostgreSQL
    • Version: 10.16
    • Templates: Free tier
    • DB Instance Identifier accept default (or provide your own)
    • Master username postgres (or provide your own)
    • Master password: elephant (or something easy to remember)
    • Public access: Yes

  3. Click Create database at the bottom of the page. If the creation is successful, you should see the following screen:

  1. In a minute you should have finished creating your database. Navigate to Connectivity & security and copy the Endpoint URL. It will look similar to database-1.chfy3h5800ty.us-west-2.rds.amazonaws.com

  2. Before we're able to connect to the RDS, we must make it accessible by modifying the default Security Group generated by AWS. To do so, click on the link under the VPC security groups subheading that looks something like default (sg-7626fd0b). Note: this link also in the Connectivity & security section.

  3. Click on Inbound rules then Edit inbound rules to navigate to the Edit inbound rules page.

  4. Set Inbound rules to Type: PostgreSQL, and Source: Anywhere, then click Save rules

  5. Open DBeaver and create a new connection to PostgreSQL and click Next.

  1. Fill in the following configurations for your new connection, supplying the endpoint you copied from AWS and the username and password configured in AWS. Instead of localhost your Host: will be the pasted endpoint from AWS.

  1. Click Test Connection and if it's successful you should see a message that says Connected and will list the server it's running on along with the driver. Click Finish.

Congratulations! You have successfully connected to your Amazon RDS where any persisted data will be managed and stored on Amazon's cloud.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment