Re: Looking for a linux tool to automate PG admin tasks - Mailing list pgsql-admin

From Keith Christian
Subject Re: Looking for a linux tool to automate PG admin tasks
Date
Msg-id CAFWoy7FrE1CB+oTbhcpdzMfQ81AxzJjwXXqxKt-zD314T6C9PA@mail.gmail.com
Whole thread Raw
In response to Looking for a linux tool to automate PG admin tasks  (Jean-Christophe Boggio <postgresql@thefreecat.org>)
List pgsql-admin
Expect comes to mind.
I've automated many CLI based systems with it.
------Keith



On Thu, Oct 16, 2025, 07:17 Jean-Christophe Boggio <postgresql@thefreecat.org> wrote:
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



pgsql-admin by date:

Previous
From: Jean-Christophe Boggio
Date:
Subject: Looking for a linux tool to automate PG admin tasks
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Looking for a linux tool to automate PG admin tasks