This application allows 1 postgres database to host multiple different projects. Thus, multiple different projects can use the same Postgres database on AWS/Azure/Google Cloud without interfering/touching/seeing each other's data.
How?
Each Postgres database can have multiple databases inside it (Yes, I know this is weird/confusing). This is why when you connect to Postgres you need to specify a specific database to connect to.
This application, when supplied adminstrative connection credentials for a Postgres instance, P, a database name, D, and a username, U, will create a new database D in P and a user with username U (and a random password composed of adjectives and animal names). It will set up database access privileges, so only U and the admin user can connect to D. This preserves privacy and prevents one codebase from messing with the data of another codebase.
By using this application, each project will have their own separate database inside of the Postgres instance and no project will be able to access any other project's data.
Note: Most likely, you won't run this code yourself because it requires administrative credentials. Rather, you will ask an admin to run the script for you, and give you the output.
Install Golang
Run (-v is for verbose)
go get -v github.com/build-umass/multitenant-pg
go get will download the source code, build it, and place the resulting binary in $GOPATH/bin. You can either run the executable by going to $GOPATH/bin, or, you can add $GOPATH/bin to your path, so all executables in that folder will be accessible from anywhere on your command prompt.
Alternatively, you can clone this repository and run go build .. A binary will be created in the current directory.
IMPORTANT FOR MAINTAINERS: The Github repository name must be kept in sync with the module name in go.mod. Otherwise, go get won't work! (But cloning the repository and running go build . will still work)
Create a .env file based off the .env.sample file and fill in the values. This executable requires connecting as an admin user, so you will need those credentials.
./multitenant-pg [username] [database name]