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

















Setting Up a PostgreSQL MCP Server in VS Code (AWS RDS, Aurora & On-Prem)

The Model Context Protocol (MCP) lets AI coding assistants talk to external systems — including your databases — through a standard interfac...