احمد ماجد

الوسم: sql

Allow remote connection to PostgreSQL
Hello,

you can connect remotely to PostgreSQL either from remote cmd of from pgAdmin by making two simple steps:

1- As a super user, open /etc/postgresql/10/main/pg_hba.conf

2- Scroll down to the line that describes local socket connections. It may look like this:
```
local all all peer
```
and add the following:
```
host all all 0.0.0.0/0 md5
```
3- In the same directory, open postgresql.conf.

Under the section on Connection Settings, add or replace the line that starts with listen_addresses to respond to all requests:
```
listen_addresses = '*'
```
4- Save and close the file.

5-Restart PostgreSQL:
```
sudo service postgresql restart
```
9 ديسمبر، 2018