PostgreSQL Password Reset | PostgreSQL Password Forgot?
Did you forget password for your PostgreSQL database server? The postgres is the super user of PostgreSQL DB server. And if you forgot the password for the postgres, you can't use the database server. Forgetting PostgreSQL password is common and frequently asked question. For this reason, I've created this video tutorial to help you, reset the postgres user password.
In this video tutorial, we will follow 5 simple steps to reset PostgreSQL password. In the first step we will locate the configuration file. Then edit the file in second step. In third step we will restart the PostgreSQL service. Then in the 4th step, we will change or reset the postgres user password. In final and 5th step we will restore configuration file and test the new credentials.
Chapters #
00:00 PostgreSQL password authentication failed error message
00:34 Step 1: Locate PostgreSQL Configuration File
01:36 Step 2: Edit PostgreSQL Configuration File
02:40 Step 3: Restart PostgreSQL Service
03:47 Step 4: Reset the postgres User Password
04:45 Step 5: Restore Original Configuration File
#PostgreSQL #Password #Forgot #Reset #Configuration #PnTutorials