Configure Insights with AWS RDS (Postgres)

RDS Postgres configuration

• Log in to AWS Management Console and search with the keyword 'RDS'. You will be redirected to the RDS Home Page

• Click on the Create Database and Select Postgres and required version

• DB Instance Settings – select type and set username and password also specify Instance Size and Storage.

• In Additional Configuration we can add initial database.

• Click On Create Database you will see the resource creation progress.

• It will take some time to provision the resources and return the Endpoint along with a few more details.

Refer: AWS RDS with Postgres Configuration

Connectivity

• PgAdmin4 – RDS Postgres

  • On the Dashboard tab, choose Add New Server.

  • In the Create

    • Server dialog box, type a name on the General tab.

  • On the Connection tab, type the details of the DB instance:

    • Enter the Host as the endpoint name.

    • Type the username and password that you entered when you created the DB instance.

    • For Port, type the assigned port: 5432.

• Grafana – RDS Postgres

  • Create user in the PgAdmin for grafana and create a database in the AWS Postgres server.

  • Open defaults.ini in grafana config folder.

  • Update the host with the RDS endpoint and add user and password in Database section.

Eg:

• Insights – RDS Postgres

  • The Insights database was created during the DB instance creation we can check that in the PgAdmin.

  • Open server-config.json in Insights-Home.

  • In the Postgres section update the username and password.

  • Also update the insightsDBUrl and grafanaDBUrl using the end point.

  • Restart the Platform service and it will generate the required table we can check that in PgAdmin.

Eg:

Postgres backup

• We can take backup of the database in our system by creating dump.sql.

• Command to create dump.sql:

  • pg_dump -h <end_point> -U <my username> -f dump.sql <db name>

  • Eg: pg_dump -h postgres.xxx.rds.amazonaws.com -U postgres -f dump.sql insight

Cost Analysis

Instance type: db.t2.large | vCPU: 2 | Memory: 8 GiB | Region: US East (N.Virginia)

Open