4,461
edits
PostgreSQL: Difference between revisions
→Configuration
m →Usage |
|||
| Line 62: | Line 62: | ||
In order to force password when logging into postgresql console change <code>ident</code> to <code>scram-sha-256</code> in <code>/var/lib/pgsql/data/pg_hba.conf</code> for IP local connections entries. This is the HBA (Host-based Authentication) configuration file for PostgreSQL. Restart afterwards. | In order to force password when logging into postgresql console change <code>ident</code> to <code>scram-sha-256</code> in <code>/var/lib/pgsql/data/pg_hba.conf</code> for IP local connections entries. This is the HBA (Host-based Authentication) configuration file for PostgreSQL. Restart afterwards. | ||
== Create a new PostgreSQL user account and a new DB == | == Create a new PostgreSQL user account and a new DB == | ||
| Line 89: | Line 90: | ||
$ created -O puser appdb | $ created -O puser appdb | ||
</syntaxhighlight> | </syntaxhighlight> | ||
= Usage = | = Usage = | ||