Re: Automation

From: "Matuszyk, Paul G(dot)" <matuszyk(at)matuszyk(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Automation
Date: 2023-10-11 16:43:25
Message-ID: CAKLx_eJ-ejSyxinL9ZiOgmS9eZ7cyLLBBh=st4o4B47oqy26wg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

On top of that pretty good rule for automation is - automate any activity
which you need to do more than 3 times e.g.
- backups
- restores
- migrations
- monitoring
- log checking

Regards
Paul G. Matuszyk

All the views expressed in this email are mine, and do not necessarily
represent those of my client (or possibly anyone else in the known
universe). No animals were harmed in the creation of this message. May
contain nuts. In order to preserve the world's resources, this email was
composed from refurbished pixels recycled from previously-used emails.
Ingredients: E-113, E-120, E-9999, EI-EI-O. If you have read this far -
don't you have anything better to do with your time?

On Wed, 11 Oct 2023 at 18:27, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Wed, Oct 11, 2023 at 8:42 AM Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
> wrote:
>
>> Help me with some hints of what kind of automation I can do here in a
>> simple postgres setup.
>>
>
> I would suggest you find at least one good reference book on PostgreSQL
> administration that covers everything involved with being a DBA. You will
> need to be aware of those regardless of automation you may choose to
> implement to avoid doing them manually. Also, automated metric collection
> tends to be important, and setting appropriate alerts (this include OS
> system administration scoped stuff like disk space) - regardless of
> whether you'd want to automated or manually resolve any events raised by
> those tools.
>
> David J.
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar 2023-10-11 18:36:04 Re: Automation
Previous Message David G. Johnston 2023-10-11 16:27:30 Re: Automation