expose pgbouncer ec2 instance parameters in PgstacDatabase construct

[hrodmn]

We had a need to update some attributes of the pgbouncer EC2 instance in MAAP recently and there is no way to do that right now.

We should add a new property to the PgstacDatabase construct like pgbouncerEC2Props that gets passed through to the Instance object.

[hrodmn]

After forwarding my email to SMCE to a new address, I got this response:

Andre Avelino commented:

Hello Henry.

This message indicates that you may have instances with security vulnerabilities present.
It also lets you know how long you have to remediate the vulnerabilities, according to our security policy and the severity of the vulnerabilities.

But I noticed that those two instances no longer exist, so you wouldn't have to worry about them right now.
But if you would like, we could meet up to go deeper into what the email means and what actions you can take when you get a notification of vulnerabilities on your instances.

Aaron Skolnik changed the status to Waiting for customer.

I'll reply and explain why we want to know if this will happen again with our new instances.

[hrodmn]

My reply (in this Jira ticket):

Thanks for the reply, Andre.

I terminated the instances and re-deployed the CloudFormation stack after we received the warning that they would get shut down. After re-deploying the stack, the AMI on the new EC2 instances was updated to a new version but nothing else changed. Without more details about the root cause my concern is that the new EC2 instances will also trigger a similar warning and be scheduled for network isolation with only one day’s notice (like the instances referenced in this thread).

Can you tell me if these instances are in violation of a security policy that will trigger a network isolation event? If so I will figure out what we need to do to permanently solve the issue.
i-0417b792e2394bafa
i-0b271861ac57d577a