Difference between revisions of "Listen addresses"

From wikieduonline
Jump to navigation Jump to search
Line 7: Line 7:
  
 
== Example modification using [[sed (editor)|sed]] ==
 
== Example modification using [[sed (editor)|sed]] ==
 
+
<code>[[sed (editor)|sed]] s/"#listen_addresses = 'localhost'"/"listen_addresses = '*'"/ /etc/postgresql/*/main/postgresql.conf</code>
[[sed (editor)|sed]] s/"#listen_addresses = 'localhost'"/"listen_addresses = '*'"/ /etc/postgresql/*/main/postgresql.conf
 
 
 
 
 
  
 
== Related ==
 
== Related ==

Revision as of 14:16, 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

Related

See also

Advertising: