How Linux sets PostgreSQL remote access

Source: Internet
Author: User
Tags postgresql

Original link:

How Linux sets PostgreSQL remote access

After the PostgreSQL database is installed, the default is to accept only local access connections. If you want to access the PostgreSQL database server on a different host, you need to configure it accordingly.

The steps to configure the remote connection PostgreSQL database are simple and only need to modify the pg_hba.conf and postgresql.conf in the data directory.

PG_HBA.CONF: Configure access to the database,

Postgresql.conf: Configures the appropriate parameters for the PostgreSQL database server.

Steps:

1. Modify the pg_hba.conf file to configure the user's access rights (#开头的行是注释内容):

# TYPE DATABASE USER cidr-address METHOD

# "Local" is for Unix domain sockets connections only

Local all All trust

# IPV4 Local connections:

Host All 127.0.0.1/32 Trust

Host All 192.168.1.0/24 MD5

# IPV6 Local connections:

Host all:: 1/128 Trust

7th is the newly added content that allows all hosts on the network segment 192.168.1.0 to access the database using all legitimate database usernames and provide encrypted password authentication.

Where the number 24 is the subnet mask, which means that the 192.168.1.0--192.168.1.255 computer is allowed access!

2. Modify the postgresql.conf file to modify the listening mode of the database server to listen for connection requests made by all hosts.

Navigate to #listen_addresses= ' localhost '. After the PostgreSQL installation is complete, the default is to accept only connection requests that come in native localhost.

Remove line start # and modify line content to listen_addresses= ' * ' to allow the database server to listen for connection requests from any host

Above is the Linux Setup PostgreSQL remote access method is introduced, if you do not set, PostgreSQL default can only be local, function is limited.

How Linux sets PostgreSQL remote access

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.