Vina Maghdalena A.Monitoring PostgreSQL: Automating Alerts for Unauthorized GRANT Commands via SlackIn my case in need to monitor permission on my database, if someone invoke grant command in my db, slack notification will be send alert.Sep 2Sep 2
Vina Maghdalena A.Efficient Backup Management: Setting Up Multiple Stanzas in pgBackRestSetting up multiple stanzas in one repository using pgBackRest allows you to manage backups for multiple PostgreSQL clusters in a single…Aug 6Aug 6
Vina Maghdalena A.Monitor Progress of your Postgresql DumpTo dump a PostgreSQL database with a progress bar in the terminal on Ubuntu, you can use the pg_dump command along with tools like pv to…Jul 1Jul 1
Vina Maghdalena A.Integrate Github on slack to get notification issue, pull, commitUntuk memudahkan deployment, kita dapat mengintegrasikan slack untuk mendapatkan notifikasi ketika seseorang melakukan pull, commit etc…Feb 5Feb 5
Vina Maghdalena A.Distributed Database using Citus with High Availability pg_autofailover part 1What is CitusJan 29Jan 29
Vina Maghdalena A.Keep PostgreSQL Logs forFor selfmanaged db log entries sent to under data directory /data/postgres/data/pg_logJan 29Jan 29
Vina Maghdalena A.Pg_logical Replication Between Two Major VersionPublication server / provider: Postgres 9.6 192.168.100.10 port 4444 Subscription server: Postgres 11 192.168.100.11 port 6666Jan 31, 2020Jan 31, 2020
Vina Maghdalena A.Logical Replication Postgres 11Create new instance on both server master and slaveJan 29, 2020Jan 29, 2020