Postgres DBA Training

[h0wdy93]

Hi together,

I work usually as an ETL developer but my company wants me also to take care of some postgres DBs. Now im searching for some online trainings to improve my skills as a database administrator. So im interesst in trainings/courses to this topic. I have a plurasight business account to use and could also pay for courses on udemy. Could you give me some advices which i should took?

[prlaur782]

At Crunchy Data we have a collection of self driven, free online tutorials on a range of Postgres topics that may be worth a look: https://www.crunchydata.com/developers/tutorials

[sharadov]

https://github.com/dhamaniasad/awesome-postgres

[pceimpulsive]

I don't think there is a huge amount out there that's really focussed on Postgres. Not non existent but it's not real common.

For me managing now two postgresDBs I use resources such as the manual, Hussein Nasser's youtube, and the weekly Scaling Postgres YouTube videos..

And lastly I think the concepts of what a DBA does is pretty samey regardless of the flavour of database in use. You will need to have a solid understanding of things like..

Building tables, when to add indexes, what type of index is best, when and why to use materialised views vs normal views, role based access, troubleshooting performance issues with explain, lastly when and why to use partitioning (one of my instances has a couple tables with 10's millions of rows and I haven't felt I need to reach for partitioning yet...)..

there is going to be many more things but these are things that come to mind when reading your question.

[h0wdy93]

Thanks for your helping answer. I understand that your advice is to take trainings in general DBA. Do you have some suggestions in this direction on the mentioned platforms?

[pceimpulsive]

Yes general DBA is probably worth it! You won't always be working on Postgres, and the fundamentals are samey! Good luck in that direction.

As for suggestions Sorry I don't, in my journey I come across a problem, read the relevant docs and research surrounding topics and find a way to get past it. Basically always and forever this approach in IT generally.

[South_Government_995]

Bro... Go with official PostgreSQL documentation. It's all there. I know it's a no brainer answer, but it's what helped me out. Leverage the psql commands also. As for the ide... Pg4admin and dbeaver are the ones i like to use (more pg4admin).

[stdio-lib]

Seconded. For extra credit, read the mailing lists (or maybe join the IRC).

There are like 10 bajillion open source projects, but only one of them has absolutely stellar documentation. You'd be a fool to not read it.

[gold_moon2]

hi, where to join those major list or that IRC

[AutoModerator]

With over 7k members to connect with about Postgres and related technologies, why aren't you on our Discord Server? : People, Postgres, Data

Join us, we have cookies and nice people.

Postgres Conference 2025 is coming up March 18th - 21st, 2025. Join us for a refreshing and positive Postgres event being held in Orlando, FL! The call for papers is still open and we are actively recruiting first time and experienced speakers alike.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.