Shulou(Shulou.com)06/01 Report--

Public network accesses internal network PostgreSQL database

The PostgreSQL database is installed on the intranet host, which can only be accessed in the local area network. How can the local PostgreSQL database be accessed from the public network?

This article describes the specific steps to implement using holer.

1. Preparation 1.1 install and start the PostgreSQL database

The default installed PostgreSQL database port is 5432.

two。 Implement step 2.1 download and extract the holer package

Holer package: holer-xxx.tar.gz

Holer supports a variety of OS system platforms, please select the holer package that matches the local OS type.

2.2 get holer access key information

Apply for your own holer access key on the holer official website or use access key information publicly available in the open source community.

For example, the holer information you applied for is as follows. Here we take the holer information as an example:

-Holer Client: holerdemo@gmail.comAccess Key: 8866daebe02846t88s166733595fff5d-Internet Address: holer.org:65014Local Address: 127.0.0.1 -2.3 start the holer service

Windows system platform:

Open the CMD console and go to the directory where the executable is located to execute the command:

Holer-windows-xxx.exe-k 8866daebe02846t88s166733595fff5d

Linux or other system platforms:

Execute the command: nohup. / holer-xxx-xxx-k 8866daebe02846t88s166733595fff5d

2.4 access the mapped public network address

Enter on the database client

Hostname: holer.org port number: 65014

This allows you to access the local PostgreSQL database from the public network.

2.5 question consultation and help

When you encounter problems in the process of using holer, you can first check the log information printed by the holer console, so that it is easy to find out the specific cause of the problem.

For more examples of using holer, please refer to the technical materials related to holer.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.