Обсуждение: Training for seasoned DBAs new to postgres?
Good day!
We have a group of Oracle and MS SQL Server DBAs who are looking to get a jump start on postgres. Would anyone here have recommendations for high-quality postgres training that focuses on administration (architecture, filesystem layout/optimization, install, configure, update/patching, backup and restore, user security, performancing tuning)? Most of the training that I have been able to find so far are more along the lines of "zero to hero", with a lot of focus on sql.
We are in Illinois, and I see that there is a Postgres user group in Chicago, but the website listed on the User Group community page seems defunct.
Thanks for your time and attention.
--
Charles Schultz
A couple folks have already responded privately with some ideas. I have another related question - for Oracle and MS SQL Server we pay for support. As Postgres is open-source, what is the popular opinion from this group on getting immediate, 24x7 support for postgres issues?
On Thu, Jul 13, 2023 at 6:43 AM Charles Schultz <sacrophyte@gmail.com> wrote:
Good day!We have a group of Oracle and MS SQL Server DBAs who are looking to get a jump start on postgres. Would anyone here have recommendations for high-quality postgres training that focuses on administration (architecture, filesystem layout/optimization, install, configure, update/patching, backup and restore, user security, performancing tuning)? Most of the training that I have been able to find so far are more along the lines of "zero to hero", with a lot of focus on sql.We are in Illinois, and I see that there is a Postgres user group in Chicago, but the website listed on the User Group community page seems defunct.Thanks for your time and attention.--Charles Schultz
Charles Schultz
Hi Charles
cybertec-postgresql do online courses of high quality in English
1)
Best regards/Venlig hilsen
Peter Gram
Sæbyholmsvej 18 DK-2500 Valby
Peter Gram
Sæbyholmsvej 18 DK-2500 Valby
Mobile: (+45) 5374 7107
Email: peter.m.gram@gmail.com
On Thu, 13 Jul 2023 at 13:43, Charles Schultz <sacrophyte@gmail.com> wrote:
Good day!We have a group of Oracle and MS SQL Server DBAs who are looking to get a jump start on postgres. Would anyone here have recommendations for high-quality postgres training that focuses on administration (architecture, filesystem layout/optimization, install, configure, update/patching, backup and restore, user security, performancing tuning)? Most of the training that I have been able to find so far are more along the lines of "zero to hero", with a lot of focus on sql.We are in Illinois, and I see that there is a Postgres user group in Chicago, but the website listed on the User Group community page seems defunct.Thanks for your time and attention.--Charles Schultz
On Thu, Jul 13, 2023 at 03:42:31PM +0200, Peter Gram wrote: > Hi Charles > > cybertec-postgresql do online courses of high quality in English > > 1) > https://www.cybertec-postgresql.com/de/training/ I am happy to second this recommendation. I've organized a week-long, admin-focussed training conducted by Laurenz Albe (himself a frequent poster on this list) from Cybertec at $prevjob back in 2020, and everyone attending felt it was time well spent. -- with best regards: - Johannes Truschnigg ( johannes@truschnigg.info ) www: https://johannes.truschnigg.info/ phone: +436502133337 xmpp: johannes@truschnigg.info
Вложения
El jue, 13 jul 2023 a la(s) 09:34, Charles Schultz (sacrophyte@gmail.com) escribió:
A couple folks have already responded privately with some ideas. I have another related question - for Oracle and MS SQL Server we pay for support. As Postgres is open-source, what is the popular opinion from this group on getting immediate, 24x7 support for postgres issues?
Hi Charles.
Postgres being open-source means you don't need to pay to use it but the art of using it well is no different than other databases.
You pay for Oracle and MS SQL support to have experts available in case of need. With Postgres it is the same. Those experts do exist and many of them happen to work for companies that provide excellent support services.
Of course you can go by without paid support and rely on the Internet and the online community of experts to provide free advice if in need. Postgres is very stable and can run for years on surprisingly well with minimal or no maintenance at all.
But... if you run mission critical databases on Postgres and your team lacks solid Postgres DBA skills, I would say that paying for support is the sound thing to do.
Regards,
Fernando