PostgreSQL Protocol: Overview

License

• Your RavenDB license determines which features are available for your server.
• Visit Studio's About page to find which features are included in your license.
• PostgreSQL is enabled for all licenses.
• To use Power BI with RavenDB as its PostgreSQL server, your license must explicitly enable Power BI.
  If your current license doesn't include Power BI Support, you can acquire one that does here.

Settings

• PostgreSQL protocol support must be explicitly enabled in your settings.
  Add this line to your server's settings.json file to enable the PostgreSQL protocol:
  

  "Integrations.PostgreSQL.Enabled": true

• PostgreSQL is an experimental feature. To enable it, enable RavenDB's Experimental Features by adding this line to your server's settings.json file:
  

  "Features.Availability": "Experimental"

PostgreSQL Port

• To access RavenDB, your clients need not only its URL but also its PostgreSQL Port number.
  By default, the port number is 5433.
• To use a different port, add the following line to your settings.json file, with a port number of your choice:
  

  "Integrations.PostgreSQL.Port": 5433

Allowing just any client to connect to your database (via PostgreSQL or otherwise) without authentication is risky, and should in general be avoided.

To allow access only for authorized clients -

• Set RavenDB as a Secure Server.
  This will allow RavenDB to authenticate PostgreSQL clients, in addition to many other security measures this setup provides.
• Create PostgreSQL Credentials using RavenDB Studio.
  PostgreSQL credentials are a user name and a password, that a client would have to provide in order to access the database.