Textpattern CMS

#49 Yesterday 17:04:48

gaekwad

Server grease monkey

From: People's Republic of Cornwall

Registered: 2005-11-19

Posts: 4,360

GitHub

Re: Adventures in Linux Land

gaekwad wrote #339892:

How do I enable password auth for the postgres user when I do psql -U postgres? I suspect it’s something to do with pg_hba.conf and likely answered here

Done (in much less than two hours, thankfully):

• Use passwd to set user account password for user postgres.
• Use sudo -u postgres psql to open PostgreSQL console.
• Use \password postgres to set the postgres user password for the console.
• Tell pg_bha.conf to use scram-sha-256 for local user(s):

local all         all              scram-sha-256

• Bounce postgresql service.
• Subsequent psql connections now need a password, even from a local connection.

---

Textpattern CMS demo – tech updates

Code is Poetry; Text is Pattern.