Looking for a linux tool to automate PG admin tasks

From: Jean-Christophe Boggio <postgresql(at)thefreecat(dot)org>
To: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Looking for a linux tool to automate PG admin tasks
Date: 2025-10-16 13:17:16
Message-ID: c07932b5-0c00-4510-8444-d52f96977938@thefreecat.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith Christian 2025-10-16 13:24:12 Re: Looking for a linux tool to automate PG admin tasks
Previous Message Muhammet Kurtoğlu 2025-10-16 12:50:20 Re: Guidance Requested: Migrating Large-Scale DB2 Databases to PostgreSQL