PostgreSQL Connection

Create a PawSQL Workspace from a PostgreSQL connection.

Requirements

• PostgreSQL Server 10, 11, 12, 13, or 14.
• Make sure your database is accessible from the machine running PawSQL

Information Needed

When we choose a PostgreSQL connection as the workspace type, we need to supply following connection information. PawSQL will connect to the database server and retrieve the table、view and indexes definition.

• Host * - The host name of the database.
• Port * - The port to connect to.
• Database * - The database name.
• Schemes * - A list of schema names.
• Username * - The user name which is used to access the database.
• Password * - The password associated with the user name.

How to access your database from internet?

• Deploy PawSQL Cloud in your own environment, contact us at service@pawsql.com
• Amazon RDS or Aliyun RDS
• Set up a reverse proxy

  • ngrok https://github.com/inconshreveable/ngrok

  • frp https://github.com/fatedier/frp

  • lanproxy https://github.com/ffay/lanproxy

  • goproxy https://github.com/snail007/goproxy

  • nps https://github.com/cnlh/nps