To connect Trevor.io to your Postgres database, login to Trevor and head to the connect Postgres screen.

You'll need to enter the following fields:

• Nickname
• Host and Port
• Database
• User and Password

You may also need to whitelist Trevor.io's IP addresses or connect via SSH.

Nickname

This is just a memorable name you choose to give this datasource.  It can be anything you like, e.g. "Our Prod Database".

Host and Port

This is the host and port of the server on which your database is hosted. 

If your database is hosted on Amazon RDS, follow these instructions to find the host and port.  If not, please contact us for help.

Whitelist IP addresses

By default, AWS will make your database inaccessible to the outside world.  Two steps are needed to allow Trevor to securely access your database:

• Ensure that your database has its "Publicly accessible" setting set to true (if not, you will need to connect via SSH instead)
• allow (i.e. whitelist) access to your database from Trevor's IP addresses.

To whitelist Trevor's IP addresses follow these instructions.

Database

This is the name of the database you want Trevor to connect to.

Easiest way to get this is to run the following command on your database:

SELECT current_database();

User and Password

This is the username and password for the database user that you want Trevor to connect as.

To create such a user please follow these instructions.

Connect via SSH

Often it is the case that your database is not directly accessible to the internet.  This is where connecting via SSH is the perfect solution.

Detailed instructions on how to do this can be found here.