Connect to Spilo

Connecting to a Spilo appliance should be the same as connecting to a PostgreSQL database or an RDS instance. Use the dns-name you specified during creation as the hostname, and use your credentials to authenticate.

Administrative connections

You will need to setup Spilo to create a database and roles for your application(s).

For example:

psql -h -p 5432 -U admin -d postgres

Application connections

Once you have created a database and roles for your application you can connect to Spilo just like you want to connect to any other PostgreSQL cluster

  • psql -h -p 5432 -U wow_app -d wow
  • "postgresql://"