Difference between revisions of "Listen addresses"

From wikieduonline
Jump to navigation Jump to search
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
 
{{lc}}
 
{{lc}}
grep listen_addresses /etc/postgresql/*/main/[[postgresql.conf]]
+
<code>grep listen_addresses /etc/postgresql/*/main/[[postgresql.conf]]</code>
  
listen_addresses = 'localhost' (Use * for listening on all addresses, review also pg_hba.conf configuration)
+
<code>listen_addresses = 'localhost' (Use * for listening on all addresses, review also pg_hba.conf configuration)</code>
  
#listen_addresses = 'localhost' # what IP address(es) to listen on;
+
<code>#listen_addresses = 'localhost' # what IP address(es) to listen on;</code>
  
 
== 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 ==
 
* <code>[[systemctl restart postgresql@14-main]]</code>
 
* <code>[[systemctl restart postgresql@14-main]]</code>
 +
listen_addresses 0.0.0.0
  
 
== See also ==
 
== See also ==

Latest revision as of 14:34, 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[edit]

sed s/"#listen_addresses = 'localhost'"/"listen_addresses = '*'"/ /etc/postgresql/*/main/postgresql.conf

Related[edit]

listen_addresses 0.0.0.0

See also[edit]

Advertising: