Deploy PostgreSQL to Kubernetes

[axelrodvl]

• Deploy PostgreSQL to DigitalOcean Kubernetes using Helm chart.
• Connect to PostgreSQL locally using port-forwarding (see README.md) from local machine using DBeaver.

[Dolph111]

@axelrodvl The status is Pending due to limited resources. https://ru.paste.pics/OS5B2 From what I understand, our resource limits are too low, and the pods are requesting more resources https://ru.paste.pics/OS51Y I need to change the Limits, but I can't figure out where to do it. I tried editing the manifest file in Ubuntu, but I can't save it, it gives me errors. I also tried modifying the values file in the charts/postgres folder, but I don't understand how to pass these values. I need some guidance to confirm if I correctly identified the issue.

[axelrodvl]

@Dolph111 That's right, we have limited resources. Try to change the helm chart CPU and memory requirements. If not possible, pick up the next task for now.

[axelrodvl]

@Dolph111 PostgreSQL is up and running. I can successfully connect to it using port-forwarding:

➜  ~ kubectl port-forward --namespace default svc/postgresql 5432:5432  
Forwarding from 127.0.0.1:5432 -> 5432
Forwarding from [::1]:5432 -> 5432
Handling connection for 5432
Handling connection for 5432

using these settings:

Try the following:

• Remove & from the end of kubectl port-forward command as this symbol is bash related and means to run the process in the background (disconnect the current terminal session). It can be an issue in Windows, but I'm unsure.
• Run netsh interface portproxy set v4tov4 listenport=8888 listenaddress=0.0.0.0 connectport=8888 connectaddress=$(wsl hostname -I) in Windows Terminal (not inside the WSL/Ubuntu!) and then try to rerun port-forwarding and connection.
• Watch this: https://www.youtube.com/watch?v=6XIewWXXSNs, it can contain a solution. Mind, that WSL (with Ubuntu) in Windows is a subsystem with totally different network interfaces than Windows. You should connect your local Windows network interface to WSL (Ubuntu).

[Dolph111]

@axelrodvl Done