Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qqbVs-000CMq-3Q
	for pgsql-admin@arkaria.postgresql.org; Wed, 11 Oct 2023 15:52:43 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qqbVo-00GvNx-7R
	for pgsql-admin@arkaria.postgresql.org; Wed, 11 Oct 2023 15:52:41 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <ronljohnsonjr@gmail.com>)
	id 1qqbVn-00GvNp-R5
	for pgsql-admin@lists.postgresql.org; Wed, 11 Oct 2023 15:52:40 +0000
Received: from mail-yb1-xb30.google.com ([2607:f8b0:4864:20::b30])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <ronljohnsonjr@gmail.com>)
	id 1qqbVm-001BSj-Ae
	for pgsql-admin@lists.postgresql.org; Wed, 11 Oct 2023 15:52:39 +0000
Received: by mail-yb1-xb30.google.com with SMTP id
 3f1490d57ef6-d9a3d4b9456so3036835276.3
        for <pgsql-admin@lists.postgresql.org>;
 Wed, 11 Oct 2023 08:52:38 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1697039557; x=1697644357;
 darn=lists.postgresql.org;
        h=content-transfer-encoding:in-reply-to:from:references:to
         :content-language:subject:user-agent:mime-version:date:message-id
         :from:to:cc:subject:date:message-id:reply-to;
        bh=UEgVGMfh2vQQgViloswuPeTFIcV7Z8CC4y2KA9SsjRs=;
        b=NB92W+uhMJFfzzVaTybknTH4wqOHfgmMODUsIPd6VxRSK9tknaL6PasrDpeniq8g2k
         aiRFTIOSdEPoGyMQG1eN6dN5ol3W2srP17Lmm3nawi7OUlFf1o5ZXiYTiwJFPB+SbsR6
         9996cN2PbsMDIKvaQ7Yl+sSHNZYEfhpYSLnFkmB/L/hffrXk7XtZevP57Fdcwe7nX8m7
         BXxejL875tBsRMgU9+TSd11QHaZeQRi6Nzv3/nSbJJeoOsR35Z5BYOgMLsb94SdvockI
         BmhJRgfFw7XWUAcwp5dXzu0gdixllqdx5ZX86AgI+m8+FvagUFmX8jwWo8gWnnZVdZfI
         33fQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1697039557; x=1697644357;
        h=content-transfer-encoding:in-reply-to:from:references:to
         :content-language:subject:user-agent:mime-version:date:message-id
         :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;
        bh=UEgVGMfh2vQQgViloswuPeTFIcV7Z8CC4y2KA9SsjRs=;
        b=vxqEYX9n0I9xN41oV6lUo4MOKmFX+9q8u+cESsuoiBWyihZ8k4v8NqDL/pALcEb3FJ
         zcaXflqWXxGAsAoukNAAMsSDNhPzxPAlYjUC/Hjyd4wHB+lmJUleYgQhuocHPETk2Voz
         h6bhwyuK4+Ewylc90gkUbzrKeTiI8BIFP5S1/lvET2ADO2acs0nfkyWaczv460DIqTsx
         GqtDyj26eZ6q28T97+tBzEox/4e1A9y0Pkjv9584j5ZhTctWIYFqa48QiWCtMOpVj/FT
         qMju/KZ41dbRKBgkK+3WOo8gl22ILntB57/wNolww9e8pTu4//mXQimw8UsRvSV0OrY5
         4/Kg==
X-Gm-Message-State: AOJu0Yzcvej31I/D1VXz9jPRf6JHw+58+s5QtSqGXH8AZqfu5vszrdB6
	oI3dR0mQX8gIhFLJs8sa/6dh7R8LAJE=
X-Google-Smtp-Source: 
 AGHT+IEPtoZBB6uljcVLTdgs2KJEu8kFspoXqOd/rjOwlsXnvRl2CBc409sRns1f1npEgiiWm3tXiw==
X-Received: by 2002:a25:97c7:0:b0:d77:91db:e5c6 with SMTP id
 j7-20020a2597c7000000b00d7791dbe5c6mr20592853ybo.17.1697039557036;
        Wed, 11 Oct 2023 08:52:37 -0700 (PDT)
Received: from ?IPV6:2600:1700:bd2c:b810:fd24:e51f:1d6f:f68d?
 ([2600:1700:bd2c:b810:fd24:e51f:1d6f:f68d])
        by smtp.googlemail.com with ESMTPSA id
 d82-20020a254f55000000b00d728a2738f1sm4506433ybb.61.2023.10.11.08.52.36
        for <pgsql-admin@lists.postgresql.org>
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Wed, 11 Oct 2023 08:52:36 -0700 (PDT)
Message-ID: <5ef686c3-5590-5c9e-547f-84050539a0ed@gmail.com>
Date: Wed, 11 Oct 2023 10:52:36 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.11.0
Subject: Re: Automation
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: 
 <CAJk5AtZF1DSMQvj7KtjYzzpAn=KzhJ0BKftCeOU6Qr7OSBjx6g@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: 
 <CAJk5AtZF1DSMQvj7KtjYzzpAn=KzhJ0BKftCeOU6Qr7OSBjx6g@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/5ef686c3-5590-5c9e-547f-84050539a0ed%40gmail.com>
Precedence: bulk

On 10/11/23 10:36, Rajesh Kumar wrote:
> I have been asked to do some of automation as a postgres dba. I have only 
> one year exp as dba.

"Some automation" is pretty ambiguous.

> Help me with some hints of what kind of automation I can do here in a 
> simple postgres setup.

What are you already doing?

-- 
Born in Arizona, moved to Babylonia.