Recommended books for admin
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
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:
Show quoted text
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
Check out the left side bar
https://www.postgresql.org/docs/
Show quoted text
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
Attachments:
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:
Show quoted text
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
Attachments:
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
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/B0CP5PPSTQThanks, 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
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]https://www.postgresql.org/docs/current/runtime-config-replication.html
(**) 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