G
G
Gryllidae2021-11-10 16:09:36
PostgreSQL
Gryllidae, 2021-11-10 16:09:36

How good is this roadmap for PostgreSQL DBA?

We are talking about this - https://roadmap.sh/postgresql-dba

maybe there is something else? when I think about learning programming technology, I think about my PET project. How to be in this case? What should I do to get some basic postgresql dba skills (on linux)?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
Melkij, 2021-11-10
@melkij

It was written by my colleague https://github.com/kamranahmedse/roadmap.sh/pull/196 Alexey Lesovsky after collecting feedback from our entire DBA team. So I'm unlikely to criticize a year later.
The roadmap has no "end". troubleshooting and optimization are endless. And even more so, the hackers theme is immense.
If you go from the development side - create a small database no matter what topic (yes, at least q&a of the service), fill it with 10-100 gigabytes of generated data and make it move in reasonable time under a synthetic load (at least pgbench). And then start changing the data schema without stopping the load. And then restore the database to the state before migration from the backup.

S
Slava Rozhnev, 2021-11-10
@rozhnev

A rare bird will reach the end of the roadmap. Start your project and upgrade your skills at the same time.
To begin with, it is enough to be able to install in the basic configuration, connect to the server and master basic SQL.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question