4

What are the basic skills and requirements a DevOps candidate should have when working with PostgreSQL? How to monitor it, deploy, etc.?

Improve this question
1
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Commented Sep 1, 2021 at 23:04

2 Answers 2

Reset to default
6

In my opinion an Operations candidate (DevOps is a culture, not a role) should be capable to perform at least the following actions:

  • deploy postgres
  • backup postgres
  • restore postgres
  • run some psql commands like select and some innerjoins
  • knows what the effect on memory usage would be if a select * is issued
  • No manual labour, only automation. Deploy the postgres using a pipeline like gitlab
  • infrastructure as code
  • monitor it, disk usage, memory, cpu
  • the difference between a relational and non-relational database
  • see also this Q&A
  • there are tools like Flyway that are capable of applying version control to databases. This could facilitate to run it in a CI/CD.
Improve this answer
2
  • 1
    if one considers devops a culture, then smooth change management is a key part of it. I wonder if you could update the answer with some reference to schema migration as part of a CI/CD pipeline?
    – Bruce Becker
    Commented Aug 31, 2021 at 5:29
  • @BruceBecker an example has been added
    – 030
    Commented Aug 31, 2021 at 6:53
2

To add to 030's answer, and as a devops engineer who has had to do this a few times, learning how to set up replication and failover in an automated fashion is very important.

If you're learning, start by setting up replication by hand on some test servers

https://www.postgresql.org/docs/13/runtime-config-replication.html

Then craft a method for automating the configuration. There are multiple ways to set up replication (they can run in parallel) and restoring a replicated database is pretty simple, but testing it out once and understanding how the file system is set up, what kinds of permissions users need to share data and what kinds of ACLs you need open between nodes to facilitate data transfer is very important.

You'd also want to craft a plan for what to do for promoting a new read/write master in case your primary node goes down.

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.