Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to log on to the PostgreSQL of other computers from the network. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

After installing PostgreSQL and testing it, let's find a good graphical interface management tool. Needless to say, it must be PGAdmin. However, as a database server, it is best not to install the graphical interface directly, so logging in to the database from another machine is the best way. The following editor will explain how to log in to the PostgreSQL of other computers from the network?

How to log in to the PostgreSQL of other computers from the network

First modify the pg_hba.conf file of pgsql:

$vi / usr/local/pgsql/data/pg_hba.conf

Find this sentence:

How to log in to the PostgreSQL of other computers from the network

Host all all 127.0.0.1/32 trust

Add a similar sentence at the bottom of this sentence. Change the ip address to the ip of the machine you want to connect to, and then restart pgsql. At this time, you need to use the postmaster command and add an extra parameter of-I:

$postmaster-I-D / usr/local/pgsql &

The "- I" entry allows access to the database from the network, which must be added if you want to develop and use Client/Server mode applications. "- D" indicates the database directory and declares the file system location of the database file. If you omit this option, the environment variable PGDATA will be used. "&" runs the listening process in the background.

Then you can log in through PGAdmin using the postgresql UserName on another machine.

This is the end of the article on "how to log on to the PostgreSQL of other computers from the network". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.