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