Difference between revisions of "Listen addresses"

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

Revision as of 07:32, 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: