This will change the users password as shown below: ALTER USER postgres WITH PASSWORD 'new_password' Step 5: Use the below command to set a new password for the postgres user.Step 4: Finally connect to PostgreSQL database server using any tool such as psql or pgAdmin: psql -U postgresĪt this stage you will not be asked for any authentication.The “C:\Program Files\PostgreSQL\12\data” is the data directory. Or use thebelow command from the window terminal: pg_ctl -D "C:\Program Files\PostgreSQL\12\data" restart On a Windows machine, you can restart the PostgreSQL from Services. Step 3: Now restart the PostgreSQL server.# Allow replication connections from localhost, by a user with the Step 2: Now change the pg_dba.conf file by making all local connections from md5 to trust.This will help you to log in to the PostgreSQL database server without using a password.Step 1: Create a backup of the pg_hba.conf file by copying it to a different location or just rename it to pg_.ISRO CS Syllabus for Scientist/Engineer Exam.ISRO CS Original Papers and Official Keys. ![]() GATE CS Original Papers and Official Keys.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |