Skip to main content
Version: Next

PostgREST

PostgREST is Web server turns PostgreSQL into a RESTful API, used for Relational Databases Database Management Tools BaaS . PostgREST is a standalone web server that turns your PostgreSQL database directly into a RESTful API. The structural constraints and permissions in the database determine the API endpoints and operations.

gui

Prepare​

When referring to this document to use PostgREST, please read and ensure the following points:

  • This application is installed by Websoft9 console.

  • The purpose of this application complies with the MIT open source license agreement.

  • Configure the domain name or server security group opens external network ports for application access.

Getting started​

Initial setup​

  1. When completed installation of PostgREST at Websoft9 Console, get the applicaiton's Overview and Access information from My Apps

  2. When installing the Websoft9 console, you need to fill in the exact Postgresql connection URI or there will be an error in the container log

Configuration options​

  • Configuration files: you can transfer configuration items via environment variables
  • Connect to Postgres database: apply orchestration to modify W9_POSTGRESQL_URI_SET in .env file

Administer​

Troubleshooting​

Database connection error?​

Ensure that the Postgresql URI is correct and can be accessed by PostgREST