Friday, June 21, 2019

How to reset forgotten password for postgres user on postgresql-10 server

1.      Take a backup pg_hba.conf file.
         C:\Program Files\PostgreSQL\10\data\pg_hba.conf


2.      Add the below line in this file and save it.

        Local      all           all           trust


3.      Restart the Postgres server

         

        Windows #
        Go to services ->then restart the service -> postgresql-10
        



        Linux #
         sudo /etc/init.d/postgresql restart

















Step by Step YugabyteDB 2.11 (Open Source) Distributed DB - Multi-node Cluster Setup on RHEL

Scope - ·        Infrastructure planning and requirement for installation of the multi-node cluster database ·        Prerequisites Software...