Difference between revisions of "Manually Configure PostgreSQL"

From truxwiki.com
Jump to navigation Jump to search
(Created page with "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...")
 
Line 9: Line 9:
 
host all all ::0/0 md5
 
host all all ::0/0 md5
 
</syntaxhighlight>
 
</syntaxhighlight>
 +
 +
=Tunable Parameters=
 +
We recommend [https://pgtune.leopard.in.ua/#/ PGTune] for getting tuning parameters.

Revision as of 13:57, 5 October 2020

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.