PostgreSQL 12 High Availability Cookbook - Third Edition

shard_manager extension

As we said earlier, building a fully functional API is beyond the scope of this book. However, we have written a reference implementation named Shard Manager, available on the PostgreSQL Extension Network (PGXN) at https://pgxn.org/dist/shard_manager/.

Shard Manager creates all of the configuration tables and functions that we discussed in this recipe, along with a couple of extras. Furthermore, it operates as a PostgreSQL extension—for example, to create a schema named shard to store the API and configuration tables, we would use the following SQL statements:

CREATE SCHEMA shard;
CREATE EXTENSION shard_manager WITH SCHEMA shard;

Documentation is currently somewhat sparse, but there is enough to install and use the ...