I have a Postgres 11 database that grew faster than expected, ultimately to around 500 million rows, and after optimizing our code we were able to get this down to around 10 million rows at any given time (around 1,000-5,000…
I want to delete one folder and its entire contents in AWS S3 using the PHP-SDK. So the equivalent of rm -rf somepath in a normal file-system. Let us assume that the folder is located at s3://somename/myfolder/1/1679666007/ and inside that…
I have a DF column which is a long strings with comma separated values, like: 2000,2001,2002:a,2003=b,2004,100,101,500,20 101,102,20 What I want to do is to create a new Array<Int> column out of it where: only values starting with 2 are included…
I am trying to set a static private IP address for a Kubernetes loadbalancer service during its creation: apiVersion: v1 kind: Service metadata: name: web-server-service-lb namespace: web annotations: service.beta.kubernetes.io/aws-load-balancer-type: "nlb-ip" service.beta.kubernetes.io/aws-load-balancer-internal: "true" service.beta.kubernetes.io/aws-load-balancer-private-ipv4-addresses: "10.9.4.55, 10.9.1.55" service.beta.kubernetes.io/aws-load-balancer-subnets: "subnet-02500d74cef5fef04, subnet-0e32bdf9ae9de8145" spec: type:…
"When attempting to create an AWS pipeline, I am encountering an issue where it fails during the Codedeploy phase and presents the error message: 'Tags cannot be empty'."
Problem: I can't: 1)use a local browser to open http://<public IP>:8000 2)use terminal to curl -v http://<public IP>:8000 3)Ping I can: 1)use terminal to run curl -v http://127.0.0.1:8000, the result indicates the django server is working. Background: I'm working on…
I have a column in my table with the name: efcodmov, every start of the month I need to extract all registers from the last month end of the code: AND efdtmov BETWEEN date('2023-01-01') AND date('2023-01-31') How can I modify…
I see weird behavior in my terraform plan and apply. I'm creating a aws_security_group resource with two ingress block settings and one dynamic ingress block, for the ingress block I'm passing as variable the additional sg rules. resource "aws_security_group" "db"…
The EKS docs in the page Amazon EKS node IAM role state that before you create worker nodes, you must create a role with the following policies: AmazonEKSWorkerNodePolicy AmazonEC2ContainerRegistryReadOnly AmazonEKS_CNI_Policy Regarding the last one, the docs state that: Rather than…
When using AWS EventBridge an event can directly trigger sending an HTTP request (to some external webhook) by using e.g. API Destinations. Is it also similarly possible for a Lambda to delegate another AWS service to send a HTTP request?…