Manually Configure PostgreSQL

From truxwiki.com
Jump to navigation Jump to search

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.