Make PostgreSQL Accessible from Outside

I will introduce how to make PostgreSQL accessible from outside clilent. ホストOSから VirtualBox の中の PostgreSQL にアクセスする方法の内容と重複する部分があります。

Procedure

Edit postgresql.conf.

Location of postgresql.conf

Arch Linux	/var/lib/postgres/data/postgresql.conf
Ubuntu	/etc/postgresql/VERSION/main/postgresql.conf
MacOS	/usr/local/var/postgres/postgresql.conf

First, add “ListenAddress”.

listen_addresses = 'localhost'

1	listen_addresses = 'localhost'

There, list all hosts you want accept the access from, as comma separated value.

listen_addresses = 'localhost,123.123.123.123'

1	listen_addresses = 'localhost,123.123.123.123'

Or write '*'. PostgreSQL will accept access from any IP addresses.

listen_addresses = '*'

1	listen_addresses = '*'

Next, edit hba.conf. It is in the same directory as postgresql.conf is in.

# IPv4 local connections:
host   all   all   remote_client_ip_address/32   trust

1 2	# IPv4 local connections: host all all remote_client_ip_address/32 trust

Set appropriate IP address to remote_client_ip_address.

At last, restart PostgreSQL.

Arch Linux

systemctl restart postgresql.service

1	systemctl restart postgresql.service

Ubuntu

sudo service postgresql restart

1	sudo service postgresql restart

MacOS

launchctl unload /usr/local/Cellar/postgresql/VERSION/homebrew.mxcl.postgresql.plist
launchctl load /usr/local/Cellar/postgresql/VERSION/homebrew.mxcl.postgresql.plist

1 2	launchctl unload /usr/local/Cellar/postgresql/VERSION/homebrew.mxcl.postgresql.plist launchctl load /usr/local/Cellar/postgresql/VERSION/homebrew.mxcl.postgresql.plist

MacOS with Homebrew