Name: pgconfus-tutorial-multi-tenant
Owner: Citus Data
Description: Files for the tutorial on Citus & Multi-Tenant Models @ PGConf US 2017
Created: 2016-11-12 22:57:04.0
Updated: 2017-12-11 18:06:20.0
Pushed: 2017-05-24 06:50:44.0
Size: 902
Language: Ruby
GitHub Committers
User | Most Recent Commit | # Commits |
---|
Other Committers
User | Most Recent Commit | # Commits |
---|
You will require a Citus Cloud formation for this tutorial, with the tutorial data pre-loaded.
In case you want to follow this at home, contact us in Slack or on the website, and we'd be happy to set you up with a tutorial formation.
Follow each section in schema_and_data.md
Follow each section in tutorial.md
Note: How to access worker nodes
Run SELECT nodename, nodeport FROM pg_dist_node
and copy one of the hostnames starting with ec2-
and ending in .com
.
Take the connection string you get from the Citus Cloud dashboard, and replace the coordinator hostname (starting with c.
and ending in .com
) with the worker hostname. Then simply use psql to connect to the worker (username, password, port and database name are the same).