How to use PostgreSQL studio to visually view the PostgreSQL database remotely

1. Download

To the website to download the latest PostgreSQL Studio, I downloaded pgstudio_1.2-bin. zip because there are no Tomcat in my computer.

If the computer has a good configuration of tomcat, you can download Pgstudio_1.2.zip, after decompression is a war package.

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

2. Decompression

Unzip the compressed file to see the following directory:

3. Run

Run in Bin directory:

./catalina.sh Run

4. View

Input in the browser: localhost:8080 can see:

4. Modifying the remote database allows access to the edited pg_hba.conf file, adding the following sentence at the bottom of the file:

Host All 0.0.0.0/0 Trust

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

listen_addresses = ' * '

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/extra/