Difference between revisions of "Listen addresses"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
#listen_addresses = 'localhost' # what IP address(es) to listen on; | #listen_addresses = 'localhost' # what IP address(es) to listen on; | ||
| + | == Example modification using [[sed]] == | ||
| + | |||
| + | [[sed]] s/"#listen_addresses = 'localhost'"/"listen_addresses = '*'"/ /etc/postgresql/*/main/postgresql.conf | ||
Revision as of 07:31, 2 February 2023
grep listen_addresses /etc/postgresql/*/main/postgresql.conf
listen_addresses = 'localhost' (Use * for listening on all addresses, review also pg_hba.conf configuration)
#listen_addresses = 'localhost' # what IP address(es) to listen on;
Example modification using sed
sed s/"#listen_addresses = 'localhost'"/"listen_addresses = '*'"/ /etc/postgresql/*/main/postgresql.conf
See also
Advertising:
