ERROR: column “…” does not exist

PostgreSQL converts all column and table names to lowercase in the SQL query. If the column or table name contains uppercase letters, we need to use double quotes to be able to reference them. When we get the error message ERROR: column “username” does not exist select * from public.”AspNetUsers” where UserName = ‘… ^ […]

PostgreSQL management tools

Install postgresql The postgresql package contains the PostgreSQL utilities: psql, pg_dump On macOS Install pgAdmin pgAdmin is a browser based database management tool for PosgtreSQL databases. Download Download the installer from Install On macOS Double click the downloaded file Accept the license agreement Drag the application into the Applications folder Start pgAdmin On macOS […]

How to remove all Docker containers and images from the host

Docker images are stored on the host to launch as fast as possible. The drawback is, Docker can fill the hard drive with unused images. A recent possible bug in Docker caused the accumulation of unused, unreferenced images on the host. To delete all Docker containers and images, use these commands in the terminal Get […]

Error: Error creating LB Listener: ValidationError: ‘arn:aws:elasticloadbalancing:….b’ must be in ARN format

We create a new AWS Application Load Balancer and get this error message when the second listener is created Error: Error creating LB Listener: ValidationError: ‘arn:aws:elasticloadbalancing:….’ must be in ARN format make sure the region and AWS profile are correctly set for the new listener config.

Learn Kubernetes part 3 – Traefik Ingress Controller

In the previous post, Learn Kubernetes part 2 – NGINX Ingress Controller, we have deployed a web application and exposed it via the kubernetes/ingress-nginx ingress controller. In this exercise we will use Traefik, another popular proxy server. Traefik is widely used for multiple reasons: it is easier to configure, can automatically generate and renew SSL […]

Learn Kubernetes part 2 – NGINX Ingress Controller

Large organizations need to control the incoming traffic to the Kubernetes cluster. The most secure way is to use an ingress controller and create an ingress to channel all incoming traffic to the cluster. In Learn Kubernetes part 1 – Web application in a Kubernetes cluster we have created a simple web application pod and […]

Kubernetes Dashboard

This is the official Kubernetes dashboard, and for security reasons currently it is not recommended to use, but we can still use it in our local cluster to inspect the resources. The latest installation information is at Launch the Kubernetes Dashboard To launch the Kubernetes Dashboard in your cluster execute the command Create a […]

Troubleshooting Kubernetes Ingress-Nginx

Use the ingress-nginx Kubernetes plugin to troubleshoot the Kubernetes Ingress-Nginx. Install krew, the Kubernetes plugin manager. See See Kubernetes Ingress-Nginx Troubleshooting made Easy with kubectl plugins Verify the cluster you are connected to To switch to another cluster Get the address of the cluster Get the list of pods Forward a port to the […]