Difference between revisions of "Manually Configure PostgreSQL"

From truxwiki.com
Jump to navigation Jump to search
Line 5: Line 5:
 
Edit the <code>pg_hba.conf</code> file to tell it to allow connections from anywhere.
 
Edit the <code>pg_hba.conf</code> file to tell it to allow connections from anywhere.
  
<sourcelang="txt">
+
<pre>
 
host all all 0.0.0.0/0 md5
 
host all all 0.0.0.0/0 md5
 
host all all ::0/0 md5
 
host all all ::0/0 md5
</source>
+
</pre>
  
 
=Tunable Parameters=
 
=Tunable Parameters=
 
We recommend [https://pgtune.leopard.in.ua/#/ PGTune] for getting tuning parameters.
 
We recommend [https://pgtune.leopard.in.ua/#/ PGTune] for getting tuning parameters.

Revision as of 16:34, 5 May 2021

Truxton will work with PostgreSQL version 9.6 through 12. If you install PostgreSQL on your own, the following changes will allow connection from anywhere.

pg_hba.conf

Edit the pg_hba.conf file to tell it to allow connections from anywhere.

host all all 0.0.0.0/0 md5
host all all ::0/0 md5

Tunable Parameters

We recommend PGTune for getting tuning parameters.