The features of muppy.io

Installation

Muppy allows you to install your PostgreSQL clusters and helps you optimize them. Muppy can install your PostgreSQL Clusters on all types of Servers; Physical or VM!Muppy allows you to manage the most complex disk configurations.

Muppy allows to manage the most complex disk configurations.

Backup / Database Restore

Muppy backs up your databases in all AWS S3 and compatible cloud storage. Muppy also manages the retention and purge of your backups.
Muppy allows you to define "Tasks" executed automatically at all stages of the restoration:

Thus, you can restore any database regardless of its configuration.Muppy also allows you to automatically chain anonymization or size reduction operations to restores.

Muppy also allows to automatically chain anonymization or size reduction operations to restorations.

Copy of Databases

With one click, copy databases between different servers and environments. Your developers will always have access to the latest versions of databases.Muppy allows you to define Tasks executed at all stages of restore or copy operations. Thus, you can restore or any database regardless of its configuration.


Security

Muppy manages the security of your PostgreSQL clusters by automatically and systematically configuring the firewall of your servers. Muppy also helps you define the contents of the pg_hba.conf file for full control of access to your Clusters and database.

Administration

Muppy has practical Administration features; User Management, Database Management, Activity Analysis, Lock Analysis,...

Streaming Replication (postgreSQL replication)

EIn seconds, configure data replication between Clusters and monitor its proper functioning.Change Primary with one click, Muppy automatically reconfigures all Standbys. You can of course add or remove Clusters whenever you want.

Change the Primary with one click, Muppy automatically reconfigures all Standbys. Of course you can add or remove clusters whenever you want.

High Availability (pglookout)

Set your policy and Muppy will automatically change Primary in the event of a failure. With its "Tasks" system, Muppy can also automatically notify or re-configure other components of your infrastructure in the event of a failover.

Monitoring of Standby servers

Muppy constantly monitors Standby servers and clusters and notifies you (via Slack, Teams) as soon as a Standby is not reachable.

Backup and Restoration PITR (wal-g)

In a few seconds, you can activate the "PITR" which will back up your Cluster every minute. Muppy then allows you to restore a Cluster to the state it was at a precise minute.

Multi-Cloud / Multi Datacenters

All Muppy features can be implemented in Multi-Cloud and/or Multi-DC.