> For the complete documentation index, see [llms.txt](https://docs.arkannis.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.arkannis.net/database/postgresql/enable-remote-access-for-postgresql.md).

# Enable remote access for PostgreSQL

By default, the PostgreSQL, server listens only on the local interface <mark style="color:orange;">`127.0.0.1`</mark>.

If you want to connect to the PostgreSQL server from remote locations, you need to set the server to listen on the public interface and edit the configuration to accept remote connections.

1. Open the configuration file <mark style="color:orange;">`postgresql.conf`</mark> and add <mark style="color:orange;">`listen_addresses = '*' in the CONNECTIONS AND AUTHENTICATION`</mark> section. This instruct the server to listen on all network interfaces.

```bash
sudo vim /etc/postgresql/11/main/postgresql.conf
```

```bash
#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------

# - Connection Settings -

listen_addresses = '*'     # what IP address(es) to listen on;
```

1. Save the file and restart the PostgreSQL service for changes to take effect:

```bash
sudo systemctl restart postgresql
```

Verify changes:

```bash
ss -nlt | grep 5432
```

```bash
LISTEN   0         128                 0.0.0.0:5432             0.0.0.0:*
LISTEN   0         128                    [::]:5432                [::]:*
```