POSTED BY
2023-05-06

Redisの場合

/usr/local/redis/etc/redis_6379.conf

bind 0.0.0.0

protected-mode no

port 6379

unixsocket /usr/local/redis/var/redis_6379.sock
unixsocketperm 777

PostgreSQLの場合 /usr/local/pgsql/data/postgresql.conf

listen_addresses = '*'          # what IP address(es) to listen on;
                                        # comma-separated list of addresses;
                                        # defaults to 'localhost'; use '*' for all
                                        # (change requires restart)
port = 5432                             # (change requires restart)

unix_socket_directories = '/usr/local/pgsql/sock'      # comma-separated list of directories
                                        # (change requires restart)
unix_socket_group = ''                 # (change requires restart)
unix_socket_permissions = 0777         # begin with 0 to use octal notation

/usr/local/pgsql/data/pg_hba.conf

192.168.0.0/24からの接続時のみ認証要求する設定例

# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
host    all             all             192.168.0.0/24           md5
# IPv6 local connections:
host    all             all             ::1/128                 trust

設定して再起動したら、netstatコマンドでちゃんと両方LISTENしてるか確認。

netstat -an | grep LISTEN

tcp        0      0 0.0.0.0:6379            0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:5432            0.0.0.0:*               LISTEN
tcp6       0      0 :::5432                 :::*                    LISTEN
unix  2      [ ACC ]     STREAM     LISTENING     2612822  /usr/local/pgsql/sock/.s.PGSQL.5432
unix  2      [ ACC ]     STREAM     LISTENING     2611863  /usr/local/redis/var/redis_6379.sock