Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.pg-sharding.tech/llms.txt

Use this file to discover all available pages before exploring further.

The application communicates with the router using the PostgreSQL protocol. In other words, the application doesn’t even know that it’s communicating with a Golang application and not a regular PostgreSQL cluster. Moreover, you can connect to the router and the coordinator via psql to perform administrative tasks. SPQR has an administrative console. You can find the console port in your config file. 
➜  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)