ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Configure a PostgreSQL database cluster to accept connections

By default, only clients running on the same machine as the PostgreSQL database cluster can connect to it. To allow remote clients to connect to the database cluster, alter the PostgreSQL pg_hba.conf configuration file.

The following steps summarize what you need to do to allow connections from clients on machines that are remote from the PostgreSQL server. The entries you place in the pg_hba.conf will vary depending on security policies and configurations at your site.

  1. Make a backup copy of the pg_hba.conf file before you alter it.
  2. If PostgreSQL is installed on a Linux server and the PostgreSQL postmaster is already running, stop it using the pg_ctl stop command.
  3. Open the pg_hba.conf file in a text editor.
  4. Add the IP addresses of connecting client machines, designate the database or databases each IP address can connect to, and specify the client authentication methods used for connections.

    See the PostgreSQL documentation for more information.

  5. Save and close the pg_hba.conf file.
  6. If PostgreSQL is installed on a Linux server, use pg_ctl to start (or restart) the PostgreSQL postmaster.

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal