Skip to content

The PGSQL subcommand implementation #14

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
Vonng opened this issue Mar 30, 2025 · 1 comment
Open

The PGSQL subcommand implementation #14

Vonng opened this issue Mar 30, 2025 · 1 comment
Assignees
Labels
enhancement New feature or request

Comments

@Vonng
Copy link
Member

Vonng commented Mar 30, 2025

Add new subcommand pig pgsql, which wrap PGSQL playbooks:

pig pgsql
pig pgsql install
pig pgsql cls add
pig pgsql cls del
pig pgsql cls info
pig pgsql cls list

pig pgsql ins add
pig pgsql ins del
pig pgsql ins info
pig pgsql ins list

pig pgsql user add
pig pgsql user del
pig pgsql user info
pig pgsql user list

pig pgsql db
pig pgsql db put [cls]
pig pgsql db del
pig pgsql db info
pig pgsql db list

pig pgsql svc put
pig pgsql svc del
pig pgsql svc info
pig pgsql svc list

pig pgsql hba
pig pgsql hba info
pig pgsql hba list

pig pgsql ext add
pig pgsql ext rm
pig pgsql ext info
pig pgsql ext list

pig pgsql ha   .....
pig pgsql pitr .....
pig pgsql pause
pig pgsql config
pig pgsql failover
pig pgsql list|pause|query|reinit|reload|remove|restart|resume



pig pgsql postgres|pg     status|start|stop|reload|restart|promote
pig pgsql patroni|pt      status|start|stop|reload|restart
pig pgsql pgbouncer|pgb   status|start|stop|reload|restart
pig pgsql pg_exporter|pge ...
pig pgsql pgbouncer_exporter|pgbe ...
pig pgsql pgbackrest_exporter|pbe ...

Similar stuff:

pig etcd cls add|rm|list|info
pig etcd ins add|rm|list|info
pig etcd env
pig etcd install
pig minio install
pig minio cls add|rm|list|info
pig minio ins add|rm|list|info
pig redis install
pig redis cls add|rm|list|info
pig redis ins add|rm|list|info
pig infra install
pig infra cert
pig infra repo upstream|build|add|pkg|boot|create|clean
@Vonng Vonng added the enhancement New feature or request label Mar 30, 2025
@Vonng Vonng self-assigned this Mar 30, 2025
@Vonng Vonng added this to pigsty Mar 30, 2025
@Vonng
Copy link
Member Author

Vonng commented Apr 22, 2025

ansible playbook alias

pig run pgsql      [sel]
pig run pgsql-add  <cls> [ins...]
pig run pgsql-rm   <cls> [ins...]
pig run pgsql-db   <cls> <dbname>
pig run pgsql-user <cls> <username>
pig run pgsql-svc  <cls>
pig run pgsql-hba  <cls>
pig run pgmon-add  <cls>
pig run pgmon-rm   <cls>

pig run node       [sel]
pig run node-add   <ip>
pig run node-rm    <ip>
pig run node-repo
pig run redis-add  <sel> [port...]
pig run redis-rm   <sel> [port...]

pig run infra  [sel]
pig run nginx
pig run cert
pig run docker [sel]
pig run repo   [sel]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
Status: No status
Development

No branches or pull requests

1 participant