[SQL] remotely using PostgreSQL Studio visualization to view the PostgreSQL database

1. Download

Go to the official website to download the latest PostgreSQL Studio, I downloaded the pgstudio_1.2-bin zip, because there is no Tomcat on my computer.

If you have tomcat configured on your computer, you can download Pgstudio_1.2.zip, which is a war package after decompression.

: http://www.postgresqlstudio.org/download/

2. Unzip

Unzip the compressed file, you can see the following directory:

3. Running

Run in the Bin directory to start Tomcat:

./catalina.sh Run

4. View

Browser input: localhost:8080 can see:

4. Modify the remote database to allow access

Edit the pg_hba.conf file and add the following sentence at the bottom of the file:

Host    all         0.0.0.0/0             

Edit the postgresql.conf file, look for the "listen_addresses" string, and then modify it as follows: