Thread

1. Recommended books for admin

   Tom Browder <tom.browder@gmail.com> — 2024-06-25T14:04:13Z

   I’m a complete novice, although I’ve dipped my toes in Admin waters a
   couple of times in my many years of using Linux.
   
   Can anyone recommend a good book on installing Postgres on multiple,
   connected multiuser systems, tuning it, managing users, backups, updated,
   etc.
   
   A cookbook/checklist approach would be great. I’ve bought several books
   over the years but a more current one is desirable.
   
   Thanks for any help.
   
   Best regards,
   
   -Tom
   

2. Re: Recommended books for admin

   Kashif Zeeshan <kashi.zeeshan@gmail.com> — 2024-06-25T14:08:09Z

   Hi Tom
   
   There is alot of stuff available online, you just need to find it, also the
   Official PG documentation is extensive too..
   
   Regards
   Kashif Zeeshan
   
   On Tue, Jun 25, 2024 at 7:04 PM Tom Browder <tom.browder@gmail.com> wrote:
   
   > I’m a complete novice, although I’ve dipped my toes in Admin waters a
   > couple of times in my many years of using Linux.
   >
   > Can anyone recommend a good book on installing Postgres on multiple,
   > connected multiuser systems, tuning it, managing users, backups, updated,
   > etc.
   >
   > A cookbook/checklist approach would be great. I’ve bought several books
   > over the years but a more current one is desirable.
   >
   > Thanks for any help.
   >
   > Best regards,
   >
   > -Tom
   >
   

3. Re: Recommended books for admin

   Bill Smith <bill.smith@enterprisedb.com> — 2024-06-25T14:09:05Z

   Check out the left side bar
   
   https://www.postgresql.org/docs/
   
   > On Jun 25, 2024, at 10:04 AM, Tom Browder <tom.browder@gmail.com> wrote:
   > 
   > I’m a complete novice, although I’ve dipped my toes in Admin waters a couple of times in my many years of using Linux.
   > 
   > Can anyone recommend a good book on installing Postgres on multiple, connected multiuser systems, tuning it, managing users, backups, updated, etc.
   > 
   > A cookbook/checklist approach would be great. I’ve bought several books over the years but a more current one is desirable.
   > 
   > Thanks for any help.
   > 
   > Best regards,
   > 
   > -Tom
   
   

4. Re: Recommended books for admin

   Muhammad Ikram <mmikram@gmail.com> — 2024-06-25T14:15:39Z

   Hi ,
   
   Here is a lately published book
   
   https://www.amazon.com/PostgreSQL-Administration-Cookbook-real-world-challenges-ebook/dp/B0CP5PPSTQ
   
   
   Muhammad Ikram
   
   Bitnine Global
   
   On Tue, 25 Jun 2024 at 19:09, Bill Smith <bill.smith@enterprisedb.com>
   wrote:
   
   > Check out the left side bar
   >
   > Documentation <https://www.postgresql.org/docs/>
   > postgresql.org <https://www.postgresql.org/docs/>
   > [image: favicon.ico] <https://www.postgresql.org/docs/>
   > <https://www.postgresql.org/docs/>
   >
   >
   > On Jun 25, 2024, at 10:04 AM, Tom Browder <tom.browder@gmail.com> wrote:
   >
   > I’m a complete novice, although I’ve dipped my toes in Admin waters a
   > couple of times in my many years of using Linux.
   >
   > Can anyone recommend a good book on installing Postgres on multiple,
   > connected multiuser systems, tuning it, managing users, backups, updated,
   > etc.
   >
   > A cookbook/checklist approach would be great. I’ve bought several books
   > over the years but a more current one is desirable.
   >
   > Thanks for any help.
   >
   > Best regards,
   >
   > -Tom
   >
   >
   >
   

5. Re: Recommended books for admin

   Tom Browder <tom.browder@gmail.com> — 2024-06-26T20:39:24Z

   On Tue, Jun 25, 2024 at 9:15 AM Muhammad Ikram <mmikram@gmail.com> wrote:
   > Hi ,
   > Here is a lately published book
   > https://www.amazon.com/PostgreSQL-Administration-Cookbook-real-world-challenges-ebook/dp/B0CP5PPSTQ
   
   Thanks, Muhammed, I just bought it.
   
   And thanks to all who answered!
   
   Best regards.
   
   -Tom
   
   
   
   

6. Re: Recommended books for admin

   Tomas Vondra <tomas.vondra@enterprisedb.com> — 2024-07-03T18:18:06Z

   On 6/26/24 22:39, Tom Browder wrote:
   > On Tue, Jun 25, 2024 at 9:15 AM Muhammad Ikram <mmikram@gmail.com> wrote:
   >> Hi ,
   >> Here is a lately published book
   >> https://www.amazon.com/PostgreSQL-Administration-Cookbook-real-world-challenges-ebook/dp/B0CP5PPSTQ
   > 
   > Thanks, Muhammed, I just bought it.
   > 
   > And thanks to all who answered!
   > 
   
   FWIW there's actually a page with a list of more books:
   
     https://www.postgresql.org/docs/books/
   
   I'd say most of the books are pretty good, from experienced authors.
   It's more about the angle of each book - sometimes it's for DBAs,
   sometimes for developers, etc.
   
   regards
   
   -- 
   Tomas Vondra
   EnterpriseDB: http://www.enterprisedb.com
   The Enterprise PostgreSQL Company
   
   
   
   

7. Re: Recommended books for admin

   Aleksander Alekseev <aleksander@timescale.com> — 2024-07-04T10:04:27Z

   Hi,
   
   > Can anyone recommend a good book on installing Postgres on multiple, connected multiuser systems, tuning it, managing users, backups, updated, etc.
   >
   > A cookbook/checklist approach would be great. I’ve bought several books over the years but a more current one is desirable.
   >
   > Thanks for any help.
   
   There are many books written but not all of them are equally well
   written to be honest.
   
   Here are several good ones in the recommended read order:
   
   - PostgreSQL Configuration by Baji Shaik (*)
   - PostgreSQL Query Optimization by Henrietta Dombrovskaya et al (**)
   - The Art of PostgreSQL by Dimitri Fontaine
   - PostgreSQL Server Programming by Hannu Krosing et al
   - PostgreSQL 14 Internals by Egor Rogov (***)
   
   (*) replication is better described in the official documentation [1]
   (**) doesn't cover such features as full-text search or PostGIS
   (***) despite the title it's written from the DBAs perspective
   
   [1]: https://www.postgresql.org/docs/current/runtime-config-replication.html
   
   -- 
   Best regards,
   Aleksander Alekseev