Untitled

unknown

plain_text

6 months ago

329 B

Indexable

Never

    • Open the pg_hba.conf file using any text editor. It is located at /etc/postgresql/[major.minor]/main/pg_hba.conf eg /etc/postgresql/12/main/pg_hba.conf location.
    • Change the following line
      local   all    postgres        peer
      to
      local   all    postgres        md5

sudo service postgresql restart