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.
  
<syntaxhighlight lang="txt>
+
<sourcelang="txt">
 
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
</syntaxhighlight>
+
</source>
  
 
=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:26, 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.

<sourcelang="txt"> host all all 0.0.0.0/0 md5 host all all ::0/0 md5 </source>

Tunable Parameters

We recommend PGTune for getting tuning parameters.