Admin Console
How to connect
Router and coordinator have administrative console. This is an app that works by PostgreSQL protocol and you can connect to it by usual psql:
➜ psql "host=localhost sslmode=verify-full user=demo dbname=demo port=7432"
SPQR router admin console
Here you can configure your routing rules
------------------------------------------------
You can find documentation here
https://github.com/pg-sharding/spqr/tree/master/docs
SHOW shards;
listing data shards
---------------------
shard id -> shard1
shard id -> shard2
(2 rows)
Administrative Console is the place where you configure the sharding logic. The router will decide which of the shards to send each request to according to the settings.
Was this page helpful?