Extra users don't get created in bitnami/postgresql-ha k8s instance

Hi all,
Reposting my post from r/postgresql. Maybe some luck here.

Troubleshooting a weird issue. I'm trying to create some users inside my bitnami/postgres-ha instance, however, not able to get it to work.

The way I approach this - I have created k8s secret with "usernames" and "passwords" keys (as per doc) which house users and passwords separated by the semicolon.

I then reference the secret inside pgpool.customUsersSecret in the values file.

Redeployed and restarted the pgpool pod. The users along with their md5 hashed pass get added to pool_passwd file inside the pgpool pod, however, if I query the users through psql with \du - nothing exists in the db.

I tried restarting the whole instance - same issue.

Creating the user manually and assigning roles give you the usual "password not stored in pool_passwd file" or "password mismatch" error upon login attempt.

Any help would be appreciated as I'm stuck atm.

I'm running bitnami/postgresql-ha chart v 8.6.13

k8s v1.22.15-gke.100

Original post: https://www.reddit.com/r/PostgreSQL/comments/zoe66k/extra_users_dont_get_created_in/

Thanks!

https://redd.it/zp1256
@r_devops

Is Azure Cosmos DB essentially Citus?

I’m looking to create a Citus server on Azure using Terraform CDK, but it seems Citus is now just Azure Cosmos DB? Can someone clear up the difference or are they essentially the same?

https://redd.it/zp86x0
@r_devops

Automate AD users and SG creation

How do you automate AD users and SG creation? It is currently a manual process and I hate it.

https://redd.it/zpbkml
@r_devops

Turn your actual feedback into a business appropriate email with AI

I probably spend more time trying to be polite in email than doing actual work. Saw a post about this on r/webdev, and thought this community might enjoy it.

Website: https://politepost.net/
Author: u/PharaohsVizier
Creator's Post: https://reddit.com/r/webdev/comments/zodwya/showoff_saturday_made_a_web_app_that_turns_your/
Engine: OpenAI

https://redd.it/zpd3ur
@r_devops

How do you integrate e2e testing to your CI CD workflow for a React frontend project?

I was wondering how to integrate it, because you can sometimes only run your E2E testing on staging after you deploy the code, but this defeats the purpose of a E2E test, because you want to run your unit test and E2E test before deploying the code, so that you can see you need to fix something before deploying to staging or production, but if you need to deploy to production to run your E2E test, it's kinda dumb, so what are you supposed to do?

https://redd.it/zpccz2
@r_devops

New to devops and setting up haproxy load balancing need help!

I am now the devops guy at our company and have limited experience after our guy left :( I have a dockerized vue frontend and a dockerized django backend. I wanted to load balance two servers. I have a third server as the load balancer/landing point.

​

* **Does the frontend go on the load balancer? Or does it go on each server ?**

​

Any input on this?

https://redd.it/zp93d0
@r_devops

Deciding between Gitlab and GitHub

I'm trying to decide which platform to move our company to. Currently on BitBucket/Jenkins. We have around 100 developers.

I came from a huge company where Gitlab was used by thousands of developers and was very successful. I was planning going down the Gitlab route based on my experience but wanted to give GitHub a fair chance. To do that, I am doing identical POCs.

The POC has to be able to deploy a microservice to Kubernetes using our various technologies (Vault, ECR, EKS, Terraform). I have this working in Gitlab on local runners.

Below is what is necessary to put into an application repo. It's super short. It builds on push, does a terraform plan across all environments on your branch. On merge, it does a plan against dev then waits for you to run an apply before moving onto the next environment. The developers don't need to know more than that unless they really want to. We are pushing a DevOps culture and expect developers to understand this but we also want to enforce certain standards such as linting, container scanning..

variables:
ENVDEV: "true"
ENVSTAGING: "true"
ENVPROD: "true"

include:
- project: 'gitlabgroup/devops/gitlab-templates/kubernetes-application'
ref: master
file: standardtemplateoption.yml

Now comes GitHub. I have been attempting this same POC with GitHub Actions, Reusable Workflows, Composite Actions, etc, etc.

The biggest issue I am having is the event handling. It would appear that there is no way to push the event handling into the "Reusable" part of the workflow/pipeline. Meaning, each repository will have to have a series of files necessary to handle on.push, on.pull\request.closed, on.push with certain tags (to create releases) and each of those files can call a shared workflow.

Am I missing something ? Maybe it's not as bad as it sounds. We only have a few hundred repos.

​

Any other factors to consider when comparing the 2? Account management? New feature release cycles? GitHub clearly has a large user community. The pricing between the 2 is pretty similar between Gitlab Premium vs. GitHub Enterprise. I wonder if they ever sell Gitlab Ultimate as the pricing is insane.

https://redd.it/zoduoz
@r_devops

What tools or systems do you use to manage your time, improve your productivity or to make your life easier?

Just interested in what tools you use for your daily struggles.

Yesterday while searching for "time management" on here I found [this thread](https://www.reddit.com/r/devops/comments/uu415b/time_and_task_management_at_work/) and was pretty pleased by the new insights the comments offered.

​

Just to start; I only have one tool that I won't live without:

* [Obsidian](https://obsidian.md/)

It's just completely overclocked note taking software that can be expanded in any way with JS.
And you can use wikilinks to connect and later visualize any snippet of knowledge.

Sadly I have nothing on the topics of time management or productivity... have always been bad at them.

https://redd.it/zplfpz
@r_devops

API gateway deployment patterns

When it comes to the deployment of API Gateways, there are 4 well-known patterns: Centralized edge gateway, Two-tier gateway, Microgateway, and Sidecar. In this post, we will go through these patterns and give you an idea to choose the right API gateway deployment pattern for your business.


https://api7.ai/blog/api-gateway-deployment-patterns

https://redd.it/zpmm1u
@r_devops

Internal metrics / KPIs for workflow scheduler platforms like Github Actions, Gitlab Pipelines, Circle CI, etc ?

Hey, is there any public documentation about setting internal / business metrics / KPIs for workflow schedulers based on containers? Even "whitebox" metrics like pulling containers / instance allocation / run time, etc. These should be generic no matter what business logic is actually in the containers. Thanks

https://redd.it/zpo3bq
@r_devops

How do job titles influence you when job hunting?

I am currently a Senior DevOps Engineer, but looking at other jobs in the DevOps/SRE space and came across a couple of jobs with titles of "Operations Engineer" or "Infrastructure Engineer".

So, I am curious what the community's thoughts are on job titles in the ops/sre/infra space and how much influence it has on your decision to go for/reject a job opportunity.

I guess for those who are in hiring positions as well - a follow on question might be how does it impact you when sifting/interviewing for a role when they have a job title that some would consider more old-fashioned?

(Please don't bring up the DevOps is not a job title its a culture point, that's been debated to death I am more curious around the other job titles floating around - thanks :))

https://redd.it/zpp2g4
@r_devops

How do you set up your local terminal / any special tools I can add to my stack?

In my quest to perfect my local set up, I made a video describing it from scratch (https://youtu.be/YDLxnHQG-LY) but here's a TL;DR (some tools are just examples, and obviously I couldn't mention every CLI on my system, BUT -> did I miss anything major? Something that's worth adding?


▶ iTerm2: https://github.com/gnachman/iTerm2
▶ Alacritty: https://github.com/alacritty/alacritty
▶ Warp: warp.dev
▶ Kitty: https://github.com/kovidgoyal/kitty
▶ Tmux: https://github.com/tmux/tmux
▶ Oh-My-Zsh: https://github.com/ohmyzsh/ohmyzsh
▶ Powerlevel10k: https://github.com/romkatv/powerlevel10k
▶ FZF: https://github.com/junegunn/fzf
▶ Z: https://github.com/rupa/z
▶ Ranger: https://github.com/ranger/ranger
▶ EXA:

https://github.com/ogham/exa
▶ XH: https://github.com/ducaale/xh
▶ Bat: https://github.com/sharkdp/bat
▶ RipGrep: https://github.com/BurntSushi/ripgrep
▶ The Silver Searcher: https://github.com/ggreer/the\_silver\_...


I'm a Neovim fan but didn't think it's part of the terminal (an IDE after all) but just in case someone mentions it...

https://redd.it/zps278
@r_devops

Devops engineers who use windows, how?

So I have been asked to switch from Linux to Windows for a month or two so I can get a good idea on how to train people up to use our stack (node, git, docker, kubernetes, ansible, AWS etc) on Windows. The problem isI haven't touched windows on a workstation in over 4 years, and that was back in my windows based sysadmin role. I have never done devopsy stuff in Windows.

I've been given some loss-od-productivity leeway, I think that time has been underestimated somewhat, but in any case I want to be able to get up to speed asap.

My first thought is just do everything in WSL, but that feels like a cheat.. is there a better way?

Software I use on a day-to-day basis
* VSCode
* docker
* awscli
* python
* bash
* powershell
* ansible
* remmina - I know windows has that rdp app but remmina is just so much better, is there a better rdp app than builtin on windows that's free?
* node
* zsh with powerlevel10k
* postman
* mtr
* nmap

https://redd.it/zpq42q
@r_devops

How to make a CI/CD of an ASP.net core app to Linux compute engine instance

I'm using Google cloud, I have a linux VM up and ready for use, I have an ASP.net core web app on Azure devops. I have configured the build pipeline for this webapp, now I want to automate its deployment on my Linux server, but I don't know how to do that.

I have 2 options I tried:

\- Building a docker container with my app and deploy on google container registry, but I couldn't find a way to later trigger the docker pull of my container on my linux VM to run it there, or run it with a docker compose.

\- Building a self contained package of the ASP.net core app, but I can't find a way of carrying the package and deploying it to my VM instance.

There are several tutorials about deploying to Google app engine, GKE etc. But I can't find one that shows how to do what I want.

Could someone please direct me to the appropriate resource ? or help me overcome this

https://redd.it/zpu12w
@r_devops

Azure function apps, Python and pyodbc module

Hello! I'm stuck in an error which I've been researching for a while now and ended up with no solutions.

I have Python code that I want to use in a Function App, more specifically, a Function App with a time trigger that runs every day at 06:00. The code:

1. Calls an API, downloads data.

2. Cleans the data.

3. Connects to a database using pyodbc module.

4. Uploads the data to the database.

Pretty simple. I then create the function app, configure it, and, locally, it's running perfectly, executing the code everyday at 06:00.

Then I create a resource and deploy the function app. The function executes properly at the configured time. However, when it runs, I get the following error:

https://imgur.com/a/rmc7XTd

https://pastebin.com/FWBECeWq

This is the overview of the function app:

https://imgur.com/a/XDetHzk

Could it be related to the fact that the application is hosted on Linux and I'm using pyodbc driver for Windows? I'm rather new to Azure so I'm a bit weak in regards to these concepts.

Using:

Windows 10 Pro

Python 3.9.13

pyodbc module

Microsoft ODBC Driver 18 for SQL Server

Microsoft SQL Server Management Studio

SQL Database is on Azure

Thank you.

https://redd.it/zq1yxt
@r_devops

I got a job offer at Amazon Europe??

Job offer at Amazon Europe..

Hello guys!

So... I just got a job offer at Amazon Europe?? And I'm not really sure about the whole situation as I'm hearing of all these layoffs (heard Amazon laid off 10k)..

Can any one give me any advice? I feel kinda lost..

For reference, I'm non EU non US citizen (Third world country) but I make a very very decent amount relative to my country..

https://redd.it/zq49a0
@r_devops

History of Docker

Hi

I am preparing an internal company talk about docker, and it's always nice to talk history. What was the main motive of starting docker? Didn't find a really good explanation

https://redd.it/zq4h3i
@r_devops

Oracle Cloud

Anyone here in Oracle Cloud?
Are happy with the choice? What feature are you missing most?

I’m using it both for personal and work projects.

Personal is good since they have a good free tier.

For work, I must admit that the Autonomous Transaction Processing is very impressive.
All other services are quite poor compared to most competitors.

Any feedback will be appreciated !

https://redd.it/zpx5qo
@r_devops

What can GitHub Actions do that CircleCI, or Jenkins or others cannot do?

Features that really set it apart. Considering your code lives in GitHub, and there are a whole bunch of features that GH provides.

https://redd.it/zqcu0c
@r_devops

question for goals in 2023

What goals does typical DevOps org put on a SRE or CICD devops role?
Like a yearly goal.
I've to invent something to satisfy mgmt, should be measurable in some way.

Thanks for your creativity :)

https://redd.it/zpxbhx
@r_devops