pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Training for seasoned DBAs new to postgres?
5+ messages / 4 participants
[nested] [flat]

* Training for seasoned DBAs new to postgres?
@ 2023-07-13 11:43  Charles Schultz <sacrophyte@gmail.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Charles Schultz @ 2023-07-13 11:43 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

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

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Training for seasoned DBAs new to postgres?
@ 2023-07-13 12:33  Charles Schultz <sacrophyte@gmail.com>
  parent: Charles Schultz <sacrophyte@gmail.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Charles Schultz @ 2023-07-13 12:33 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

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

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Training for seasoned DBAs new to postgres?
@ 2023-07-13 13:42  Peter Gram <peter.m.gram@gmail.com>
  parent: Charles Schultz <sacrophyte@gmail.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Peter Gram @ 2023-07-13 13:42 UTC (permalink / raw)
  To: sacrophyte@gmail.com; +Cc: pgsql-admin@lists.postgresql.org

Hi Charles

cybertec-postgresql do online courses of high quality in English

1)
https://www.cybertec-postgresql.com/de/training/

Best regards/Venlig hilsen

Peter Gram
Sæbyholmsvej 18 DK-2500 Valby

Mobile: (+45) 5374 7107
Email: peter.m.gram@gmail.com

<http://oaktable.net/members;


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
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Training for seasoned DBAs new to postgres?
@ 2023-07-13 14:12  Johannes Truschnigg <johannes@truschnigg.info>
  parent: Peter Gram <peter.m.gram@gmail.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Johannes Truschnigg @ 2023-07-13 14:12 UTC (permalink / raw)
  To: Peter Gram <peter.m.gram@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org

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

Attachments:

  [application/pgp-signature] signature.asc (832B, ../../ZLAGUKC+QQr4KtBO@vault.lan/2-signature.asc)
  download

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Training for seasoned DBAs new to postgres?
@ 2023-07-14 03:50  Fernando Hevia <fhevia@gmail.com>
  parent: Charles Schultz <sacrophyte@gmail.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Fernando Hevia @ 2023-07-14 03:50 UTC (permalink / raw)
  To: sacrophyte@gmail.com; +Cc: pgsql-admin@lists.postgresql.org

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

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2023-07-14 03:50 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-07-13 11:43 Training for seasoned DBAs new to postgres? Charles Schultz <sacrophyte@gmail.com>
2023-07-13 12:33 ` Charles Schultz <sacrophyte@gmail.com>
2023-07-14 03:50   ` Fernando Hevia <fhevia@gmail.com>
2023-07-13 13:42 ` Peter Gram <peter.m.gram@gmail.com>
2023-07-13 14:12   ` Johannes Truschnigg <johannes@truschnigg.info>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox