PostgreSQL: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

20 June 2024

  • curprev 11:0511:05, 20 June 2024Qljca talk contribs 3,560 bytes +1,185 No edit summary
  • curprev 09:1209:12, 20 June 2024Qljca talk contribs 2,375 bytes +2,375 Created page with "==PostgreSQL SQL error== ===password authentication failed=== <pre>psql: FATAL: password authentication failed for user "postgres" password retrieved from file "/var/lib/pgsql/.pgpass"</pre> <pre> Solution: cp /var/lib/pgsql/9.6/data/pg_hba.conf /var/lib/pgsql/9.6/data/pg_hba.conf_backup chattr -aie /var/lib/pgsql/data/pg_hba.conf Copy the password from: cat /var/lib/pgsql/.pgpass Login to WHM > Configure PostgreSQL and update the password. Then, ----ia-------e-- /v..."