[SQL] remotely using PostgreSQL Studio to visually view PostgreSQL databases

1. Download

Go to the official website to download the latest PostgreSQL Studio, I downloaded pgstudio_1.2-bin. zip, because my computer does not have tomcat.

If Tomcat is configured on your computer, download pgstudio_1.2.zip and decompress the package.

: Http://www.postgresqlstudio.org/download/

2. Extract

Decompress the compressed file and you can see the following directory:

3. Run

Run in the bin directory and start tomcat:

./Catalina. sh run

4. View

Enter localhost: 8080 in the browser and you will see:

4. Modify the remote database to allow access

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

Host all 0.0.0.0/0 trust

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

Listen_addresses = '*'