[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 Pgstudio_1.2-bin zip, because there is no Tomcat on my computer.

Suppose you have a computer with Tomcat configured to download Pgstudio_1.2.zip and then a war package after decompression.

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

2. Unzip

Unzip the compressed file to see, for example, the following folder:

3. Implementation

Execute under the Bin folder to start Tomcat:

./catalina.sh Run

4. View

Browser input: localhost:8080 will be able to see:

4. Change the remote database to agree to interview

Edit the pg_hba.conf file and add the following phrase 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 change to such as the following:

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