MIME-Version: 1.0
References: <c07932b5-0c00-4510-8444-d52f96977938@thefreecat.org>
 <aPD3JdsnLaQ6gEY0@depesz.com>
In-Reply-To: <aPD3JdsnLaQ6gEY0@depesz.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 16 Oct 2025 10:11:37 -0400
Message-ID: 
 <CANzqJaAo8XiBTFrAKUSUwGseF1vHSR2hYW-Fod9ZqEhAuA7Frg@mail.gmail.com>
Subject: Re: Looking for a linux tool to automate PG admin tasks
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a4858e06414732de"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaAo8XiBTFrAKUSUwGseF1vHSR2hYW-Fod9ZqEhAuA7Frg%40mail.gmail.com>
Precedence: bulk

--000000000000a4858e06414732de
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Oct 16, 2025 at 9:46=E2=80=AFAM hubert depesz lubaczewski <depesz@d=
epesz.com>
wrote:

> On Thu, Oct 16, 2025 at 03:17:16PM +0200, Jean-Christophe Boggio 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 som=
e
> > 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.
>
> Well, I'd just use psql, with some simple script using \gexec
> functionality. Solves virtually any problem of this kind.
>

Ditto.  bash scripts are only ugly if you write ugly bash.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Oct 16, 2025 at 9:46=E2=80=AFAM h=
ubert depesz lubaczewski &lt;<a href=3D"mailto:depesz@depesz.com">depesz@de=
pesz.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_containe=
r"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex">On Thu, Oct 16, 2025 a=
t 03:17:16PM +0200, Jean-Christophe Boggio wrote:<br>
&gt; Hello,<br>
&gt; I have several servers with many databases on them for different<br>
&gt; applications.<br>
&gt; I need to execute some tasks on some databases depending on some crite=
ria.<br>
&gt; For example, execute query xxx but only on databases where table<br>
&gt; public.sometable exists or if number of rows in table yyy is &gt; 1M.<=
br>
&gt; Before reinventing the wheel with ugly bash scripts, do you know of so=
me<br>
&gt; tools that would suit my case ?<br>
&gt; Some tasks will have to execute periodically (with crons probably) and=
<br>
&gt; others will be one-off.<br>
&gt; CLI tools if possible because I&#39;m working remotely on those server=
s of<br>
&gt; course.<br>
<br>
Well, I&#39;d just use psql, with some simple script using \gexec<br>
functionality. Solves virtually any problem of this kind.<br></blockquote><=
div></div></div><div><br></div><div>Ditto.=C2=A0 bash scripts are only ugly=
 if you write ugly bash.</div><div><br></div><span class=3D"gmail_signature=
_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=
=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me=
, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></=
div></div></div></div>

--000000000000a4858e06414732de--