NOTE – THAT AGENT IN THE RDS INSTALLATION MAY MONITOR MORE THAN ONE POSTGRES RDS SERVICE. YOU SHOULD INSTALL AN AGENT ON ANOTHER MACHINE WE CALL A “JUMP SERVER.”. THIS MACHINE SHOULD BE IN THE SAME SECURITY GROUP AS THE RDS.
Step 1: Select PostgreSQL
In the pop-up window you need to select PostgreSQL and click the “Next” button to navigate to the next page.
Step 2: Enter Jump Host IP
In the second step, you will enter the jump host IP (indicated by the number 1 in the figure above). The jump host IP address can be taken from EC2->Instances->…. .
Copy the Private IP Address and paste it into the Jump Host ID field.
To see the example of the role policy, you need to click on the link in the red rectangle. Role policy example:
Before proceeding to the next step, check that the parameters in the red rectangle are the same as those in your parameters group.
Note – if you must change at least one of the parameters, you cannot do this in the default parameters group. Simply duplicate your default parameters group and make all necessary changes there
Check that Enhanced Monitoring checkbox is enabled, as shown in the figure above.
Then, click the “Next” button to continue.
Step 3: Copy Command and Login
In this step, you must first select the type of OS (indicated by the number 1 in the figure above) and then its version (indicated by the number 2 in the figure above). After that, the installation commands will appear, copy them (indicated by the numbers 3-6) and log in as sudo to the Jump Server by pasting the copied command into the Command-Line Interface and running it in the terminal.
When the installation is complete, you will be asked to insert the Metadata. Copy this from the UI (indicated by the number 1) and paste it into the Command Line (indicated by the number 2 above), then press Enter.
After the installation has completed successfully, click the “Next” button on the UI page to continue.
To avoid future problems, you must refresh the status of the agent (indicated by the number 1 on the figure above) in case of errors during installation.
Step 4: Configure Instance
In this step, a command is presented that will configure the instance. Copy this command from the UI and paste it into the CLI that is already open from the previous step.
When executing this command, enter the following six parameters:
- RDS Instance identifier.
The RDS Instance identifier can be taken from RDS->Databases.
- RDS Instance location region.
The RDS Instance location region can be taken from RDS->Databases. As you can see in the figure above, you do not need to take the ending of the identifier.
- A valid database name in your PostgreSQL.
- A superuser name – this will be used just one time to configure and restart the PostgreSQL Instance.
- The password of the superuser – this is the password for the superuser entered above.
- Define and type the password for the Awide user with which the user will to connect to PostgreSQL. With that user, Awide will connect to Postgres to collect metrics and perform all necessary management actions.
- The superuser is used only once, for the complete configuration and restart of the server following the installation. The superuser credentials will not be stored in any place.
Click the “Next” button to continue to the next page.
Step 5: Complete Installation
Next, validate the installation and click the “Next” button when you are ready to continue.
Now, take a break for five minutes, and AWIDE will collect the information about your instance. You will see the new instance appear in the instances list. Click the instance to see your completed PostgreSQL installation.
Leave a Reply