Difference between revisions of "Listen addresses"

From wikieduonline
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]] ==
+
== Example modification using [[sed (editor)|sed]] ==
  
 
  [[sed]] s/"#listen_addresses = 'localhost'"/"listen_addresses = '*'"/ /etc/postgresql/*/main/postgresql.conf
 
  [[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: