MIME-Version: 1.0
References: <c07932b5-0c00-4510-8444-d52f96977938@thefreecat.org>
 <aPD3JdsnLaQ6gEY0@depesz.com>
 <CANzqJaAo8XiBTFrAKUSUwGseF1vHSR2hYW-Fod9ZqEhAuA7Frg@mail.gmail.com>
In-Reply-To: 
 <CANzqJaAo8XiBTFrAKUSUwGseF1vHSR2hYW-Fod9ZqEhAuA7Frg@mail.gmail.com>
From: =?UTF-8?Q?Roland_M=C3=BCller?= <rolmur@gmail.com>
Date: Fri, 17 Oct 2025 07:16:24 +0300
Message-ID: 
 <CA+8p0G3o+nOXtiEBAEWntxpqjep-SRBVTtT0+NhEAdzTUWXcpw@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="000000000000fb3db7064152ffcf"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2B8p0G3o%2BnOXtiEBAEWntxpqjep-SRBVTtT0%2BNhEAdzTUWXcpw%40mail.gmail.com>
Precedence: bulk

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

May be Ansible? There is a dedicated module for Postgresql and a lot of
modules for general tasks such as installation etc.
https://docs.ansible.com/ansible/latest/collections/community/postgresql/in=
dex.html

Br
Roland

Ron Johnson <ronljohnsonjr@gmail.com> ezt =C3=ADrta (id=C5=91pont: 2025. ok=
t. 16., Cs
17:12):

> On Thu, Oct 16, 2025 at 9:46=E2=80=AFAM hubert depesz lubaczewski <
> depesz@depesz.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 so=
me
>> > 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.
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>

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

<div dir=3D"auto">May be Ansible? There is a dedicated module for Postgresq=
l and a lot of modules for general tasks such as installation etc. <a href=
=3D"https://docs.ansible.com/ansible/latest/collections/community/postgresq=
l/index.html">https://docs.ansible.com/ansible/latest/collections/community=
/postgresql/index.html</a><div dir=3D"auto"><br></div><div dir=3D"auto">Br<=
/div><div dir=3D"auto">Roland=C2=A0</div></div><br><div class=3D"gmail_quot=
e gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">Ron Johnson =
&lt;<a href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</a>&=
gt; ezt =C3=ADrta (id=C5=91pont: 2025. okt. 16., Cs 17:12):<br></div><block=
quote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1=
px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"lt=
r">On Thu, Oct 16, 2025 at 9:46=E2=80=AFAM hubert depesz lubaczewski &lt;<a=
 href=3D"mailto:depesz@depesz.com" target=3D"_blank" rel=3D"noreferrer">dep=
esz@depesz.com</a>&gt; wrote:</div><div class=3D"gmail_quote"><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px soli=
d rgb(204,204,204);padding-left:1ex">On Thu, Oct 16, 2025 at 03:17:16PM +02=
00, 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>
</blockquote></div>

--000000000000fb3db7064152ffcf--