Postgres Pro
Downloads
Home   >   mailing lists

Thread: Recommended books for admin

Recommended books for admin

From
Tom Browder
Date:
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

Re: Recommended books for admin

From
Kashif Zeeshan
Date:
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

Re: Recommended books for admin

From
Bill Smith
Date:
Check out the left side bar



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

Attachment

Re: Recommended books for admin

From
Muhammad Ikram
Date:
Hi ,

Here is a lately published book

Bitnine Global 

On Tue, 25 Jun 2024 at 19:09, Bill Smith <bill.smith@enterprisedb.com> wrote:


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

Attachment

Re: Recommended books for admin

From
Tom Browder
Date:
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

Re: Recommended books for admin

From
Tomas Vondra
Date:
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

Re: Recommended books for admin

From
Aleksander Alekseev
Date:
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