MIME-Version: 1.0
References: <c07932b5-0c00-4510-8444-d52f96977938@thefreecat.org>
In-Reply-To: <c07932b5-0c00-4510-8444-d52f96977938@thefreecat.org>
From: Keith Christian <keith1christian@gmail.com>
Date: Thu, 16 Oct 2025 07:24:12 -0600
Message-ID: 
 <CAFWoy7FrE1CB+oTbhcpdzMfQ81AxzJjwXXqxKt-zD314T6C9PA@mail.gmail.com>
Subject: Re: Looking for a linux tool to automate PG admin tasks
To: Jean-Christophe Boggio <postgresql@thefreecat.org>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000088ae40641468949"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFWoy7FrE1CB%2BoTbhcpdzMfQ81AxzJjwXXqxKt-zD314T6C9PA%40mail.gmail.com>
Precedence: bulk

--000000000000088ae40641468949
Content-Type: text/plain; charset="UTF-8"

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
>
>
>
>

--000000000000088ae40641468949
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Expect comes to mind.<div dir=3D"auto">I&#39;ve automated=
 many CLI based systems with it.</div><div dir=3D"auto">------Keith<br><div=
 dir=3D"auto"><br></div><div dir=3D"auto"><br></div></div></div><br><div cl=
ass=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_a=
ttr">On Thu, Oct 16, 2025, 07:17 Jean-Christophe Boggio &lt;<a href=3D"mail=
to:postgresql@thefreecat.org">postgresql@thefreecat.org</a>&gt; wrote:<br><=
/div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-le=
ft:1px #ccc solid;padding-left:1ex">Hello,<br>
I have several servers with many databases on them for different <br>
applications.<br>
I need to execute some tasks on some databases depending on some criteria.<=
br>
<br>
For example, execute query xxx but only on databases where table <br>
public.sometable exists or if number of rows in table yyy is &gt; 1M.<br>
Before reinventing the wheel with ugly bash scripts, do you know of some <b=
r>
tools that would suit my case ?<br>
Some tasks will have to execute periodically (with crons probably) and <br>
others will be one-off.<br>
CLI tools if possible because I&#39;m working remotely on those servers of =
<br>
course.<br>
Thanks,<br>
JC<br>
<br>
<br>
<br>
</blockquote></div>

--000000000000088ae40641468949--