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 myfirstspilo.example.com -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 myfirstspilo.example.com -p 5432 -U wow_app -d wow
• "postgresql://myfirstspilo.example.com:5432/wow?user=wow_app"