Original-Subject: Looking for a linux tool to automate PG admin tasks
Original-From: Jean-Christophe Boggio <postgresql@thefreecat.org>
Message-ID: <c07932b5-0c00-4510-8444-d52f96977938@thefreecat.org>
Date: Thu, 16 Oct 2025 15:17:16 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Content-Language: en-US, fr
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
From: Jean-Christophe Boggio <postgresql@thefreecat.org>
Subject: Looking for a linux tool to automate PG admin tasks
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/c07932b5-0c00-4510-8444-d52f96977938%40thefreecat.org>
Precedence: bulk

Hello,
I have several servers with many databases on them for different 
applications.
I need to execute some tasks on some databases depending on some criteria.

For example, execute query xxx but only on databases where table 
public.sometable exists or if number of rows in table yyy is > 1M.
Before reinventing the wheel with ugly bash scripts, do you know of some 
tools that would suit my case ?
Some tasks will have to execute periodically (with crons probably) and 
others will be one-off.
CLI tools if possible because I'm working remotely on those servers of 
course.
Thanks,
JC