| From: | Roland Müller <rolmur(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Looking for a linux tool to automate PG admin tasks |
| Date: | 2025-10-17 04:16:24 |
| Message-ID: | CA+8p0G3o+nOXtiEBAEWntxpqjep-SRBVTtT0+NhEAdzTUWXcpw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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/index.html
Br
Roland
Ron Johnson <ronljohnsonjr(at)gmail(dot)com> ezt írta (időpont: 2025. okt. 16., Cs
17:12):
> On Thu, Oct 16, 2025 at 9:46 AM hubert depesz lubaczewski <
> depesz(at)depesz(dot)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 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.
>>
>> 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!
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2025-10-17 06:49:40 | Re: postgres server crash with "Segmentation fault" |
| Previous Message | Willian Colognesi | 2025-10-17 00:52:43 | Re: postgres server crash with "Segmentation fault" |