Как сбросить пароль postgres windows

I either forgot or mistyped (during the installation) the password to the default user of PostgreSQL. I can’t seem to be able to run it, and I get the following error:

psql: FATAL:  password authentication failed for user "hisham"
hisham-agil: hisham$ psql

Is there a way to reset the password or how do I create a new user with superuser privileges?

I am new to PostgreSQL and just installed it for the first time. I am trying to use it with Ruby on Rails and I am running Mac OS X v10.7 (Lion).

Peter Mortensen's user avatar

asked Jun 1, 2012 at 7:14

hilarl's user avatar

1

  1. Find the file pg_hba.conf. It may be located, for example, in /etc/postgresql-9.1/pg_hba.conf.

    cd /etc/postgresql-9.1/

  2. Back it up

    cp pg_hba.conf pg_hba.conf-backup

  3. Place the following line (as either the first uncommented line, or as the only one):

    For all occurrence of below (local and host) , except replication
    section if you don’t have any it has to be changed as follow ,no MD5
    or Peer authentication should be present.

    local all all trust

  4. Restart your PostgreSQL server (e.g., on Linux:)

    sudo /etc/init.d/postgresql restart

    If the service (daemon) doesn’t start reporting in log file:

    local connections are not supported by this build

    you should change

    local all all trust

    to

    host all all 127.0.0.1/32 trust

  5. You can now connect as any user. Connect as the superuser postgres (note, the superuser name may be different in your installation. In some systems it is called pgsql, for example.)

    psql -U postgres

    or

    psql -h 127.0.0.1 -U postgres

    (note that with the first command you will not always be connected with local host)

  6. Reset the password (‘replace my_user_name with postgres since you are resetting the postgres user)

    ALTER USER my_user_name with password 'my_secure_password';

  7. Restore the old pg_hba.conf file as it is very dangerous to keep around

    cp pg_hba.conf-backup pg_hba.conf

  8. Restart the server, in order to run with the safe pg_hba.conf file

    sudo /etc/init.d/postgresql restart

Further reading about that pg_hba file: 19.1. The pg_hba.conf File (official documentation)

Peter Mortensen's user avatar

answered Jun 1, 2012 at 7:42

Arsen7's user avatar

Arsen7Arsen7

12.5k2 gold badges43 silver badges60 bronze badges

19

When connecting to PostgreSQL from the command line, don’t forget to add -h localhost as a command line parameter. If not, PostgreSQL will try to connect using PEER authentication mode.

The below shows a reset of the password, a failed login with PEER authentication and a successful login using a TCP connection.

# sudo -u postgres psql

could not change directory to "/root"
psql (9.1.11)
Type "help" for help.

postgres=# \password
Enter new password:
Enter it again:
postgres=# \q

Failing:

# psql -U postgres -W

Password for user postgres:
psql: FATAL:  Peer authentication failed for user "postgres"

Working with -h localhost:

# psql -U postgres -W  -h localhost

Password for user postgres:
psql (9.1.11)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.

postgres=#

Peter Mortensen's user avatar

answered Feb 2, 2014 at 10:21

SaeX's user avatar

SaeXSaeX

17.3k16 gold badges77 silver badges97 bronze badges

1

The pg_hba.conf (C:\Program Files\PostgreSQL\9.3\data) file has changed since these answers were given. What worked for me, in Windows, was to open the file and change the METHOD from md5 to trust:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust

Then, using pgAdmin III, I logged in without using a password and changed user postgres‘s password by going to menu FileChange Password.

Peter Mortensen's user avatar

answered Sep 19, 2014 at 22:26

SaiyanGirl's user avatar

SaiyanGirlSaiyanGirl

16.4k11 gold badges41 silver badges57 bronze badges

6

For Windows (what has helped me):

This is the document I am referring to: How can I reset a PostgreSQL password?

  1. Open your cmd and go to C:\Program Files\PostgreSQL\12\data.
    This is usually the right path. You might have it stored somewhere else. Note that, if you have a different PostgreSQL version, there will be a different number. That doesn’t matter.

  2. Find a pg_hba.conf file and copy it to somewhere else (that way you will have an unmodified version of this file, so you will be able to look at it after we make some changes)

  3. Open the pg_hba.conf file (not the backup, but the original)

  4. Find the multiple lines that start with host near the bottom of the file:

    host    all             all             127.0.0.1/32            md5
    
    host    all             all             ::1/128                 md5
    
    host    replication     all             127.0.0.1/32            md5
    
    host    replication     all             ::1/128                 md5
    
  5. Replace md5 with trust:

    host    all             all             127.0.0.1/32            trust
    
    host    all             all             ::1/128                 trust
    
    host    replication     all             127.0.0.1/32            trust
    
    host    replication     all             ::1/128                 trust
    
  6. Close this file

  7. Go to your search bar on windows and open Services app. Find postgres and restart it.

    Picture of services app

  8. Write cd.. in cmd and then cd bin. Your path should be C:\Program Files\PostgreSQL\12\bin

  9. Enter: psql -U postgres -h localhost

  10. Enter: ALTER USER postgres with password '<your new password>';Make sure that you include ; at the end
    “ALTER ROLE” should be displayed as an indication that the previous line was executed successfully

  11. Open original pg_hba.conf file and change back from trust to md5

  12. Restart the server with Services app as before

Peter Mortensen's user avatar

answered Nov 15, 2020 at 22:14

Vito Farina's user avatar

Vito FarinaVito Farina

2713 silver badges2 bronze badges

1

I was just having this problem on Windows 10 and the issue in my case was that I was just running psql and it was defaulting to trying to log in with my Windows username («Nathan»), but there was no PostgreSQL user with that name, and it wasn’t telling me that.

So the solution was to run psql -U postgres rather than just psql, and then the password I entered at installation worked.

answered Jun 26, 2019 at 21:29

Nathan Wailes's user avatar

Nathan WailesNathan Wailes

10k7 gold badges59 silver badges98 bronze badges

0

  1. Edit the file /etc/postgresql/<version>/main/pg_hba.conf and find the following line:

    local  all  postgres  md5
    
  2. Edit the line and change md5 at the end to trust and save the file

  3. Reload the postgresql service

    sudo service postgresql reload
    
  4. This will load the configuration files. Now you can modify the postgres user by logging into the psql shell

    psql -U postgres
    
  5. Update the postgres user’s password

    alter user postgres with password 'secure-passwd-here';
    
  6. Edit the file /etc/postgresql/<version>/main/pg_hba.conf and change trust back to md5 and save the file

  7. Reload the postgresql service

    sudo service postgresql reload
    
  8. Verify that the password change is working

    psql -U postgres -W
    

Peter Mortensen's user avatar

answered Aug 17, 2017 at 2:55

Ray Hunter's user avatar

Ray HunterRay Hunter

15.2k5 gold badges53 silver badges51 bronze badges

2

Just a note: On Linux, you can simply run sudo su - postgres to become the postgres user and from there change what is required using psql.

Peter Mortensen's user avatar

answered Mar 12, 2018 at 12:58

Daniel's user avatar

DanielDaniel

1991 silver badge4 bronze badges

1

For a Windows user for the latest PostgreSQL version (greater than 10):

Go to your PostgreSQL installation location, and search for pg_hba.conf, you will find it in ..\postgres\data\pg_hba.conf.

Open that file with Notepad, and find this line:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
#..

Change the method from *md5* to *trust*:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust
# ...

Now go to your SQL shell (PSQL) and leave everything blank,

Server [localhost]:
Database [postgres]:
Port [8000]:
Username [postgres]:

It will not ask for a password this time, and you will be logged in,

Now run this line:

  `ALTER USER yourusername WITH SUPERUSER`

Now you can leave the shell with \q.

Again, go to the file pg_hba.conf and change METHOD from trust to md5 again, and save it.

Now log in with your new user and password, and you can check \du for its attributes.

Peter Mortensen's user avatar

answered Feb 3, 2019 at 13:40

Bidhan Majhi's user avatar

Bidhan MajhiBidhan Majhi

1,3201 gold badge12 silver badges25 bronze badges

If you are running PostgreSQL on macOS, try these:

1. Edit the pg_hba.conf file

sudo vi /Library/PostgreSQL/9.2/data/pg_hba.conf
and Change the «md5» method for all users to «trust» near the bottom of the file

2. Find the name of the postgres service

ls /Library/LaunchDaemons
Look for postgresql

3. Restart the postgresql service

sudo launchctl stop com.edb.launchd.postgresql-9.2

sudo launchctl start com.edb.launchd.postgresql-9.2 (com.edb.launchd.postgresql-9.2 should be name postgresql service from step 3)

4. Start a psql session as postgres
psql -U postgres
(shouldn’t ask for password because of ‘trust’ setting)

5. Reset password in the psql session by typing:

    ALTER USER postgres with password 'secure-new-password';

6. Edit the pg_hba.conf file
Switch it back to ‘md5’

8. Restart services again

Sostene MUNEZERO BAGIRA's user avatar

answered Mar 16, 2020 at 15:22

David's user avatar

DavidDavid

3,86333 silver badges36 bronze badges

For a Windows installation, a Windows user is created. And «psql» uses this user for connection to the port. If you change the PostgreSQL user’s password, it won’t change the Windows one.
The command line just below works only if you have access to the command line.

Instead, you could use the Windows GUI application «c:\Windows\system32\lusrmgr.exe». This application manages users created by Windows. So you can now modify the password.

Peter Mortensen's user avatar

answered Mar 21, 2017 at 15:31

cpunky's user avatar

2

I did this to resolve the same problem:

Open the pg_hba.conf file with the gedit editor from the terminal:

sudo gedit /etc/postgresql/9.5/main/pg_hba.conf

It will ask for a password. Enter your admin login password.
This will open gedit with the file. Paste the following line:

host  all   all  127.0.0.1/32  trust
just below -

# Database administrative login by Unix domain socket

Save and close it.

Close the terminal, open it again and run this command:

psql -U postgres

You will now enter the psql console.

Now change the password by entering this:

ALTER USER [your preferred user name] with password '[desired password]';

If it says the user does not exist then instead of ALTER, use CREATE.

Lastly, remove that certain line you pasted in pg_hba and save it.

Peter Mortensen's user avatar

answered Nov 14, 2017 at 12:08

Taufiq Rahman's user avatar

Taufiq RahmanTaufiq Rahman

5,6302 gold badges37 silver badges44 bronze badges

sudo -u postgres psql

ALTER USER user_name WITH PASSWORD 'new_password';

desertnaut's user avatar

desertnaut

57.9k27 gold badges140 silver badges167 bronze badges

answered May 21 at 11:20

sina adibfar's user avatar

1

If you are on Windows you can just run

net user postgres postgres

And log in in PostgreSQL with postgres/postgres as the user/password.

Peter Mortensen's user avatar

answered Jun 7, 2016 at 16:36

ivofernandes's user avatar

0

Follow step 1 on the best answer.

Here is my addition if you use the Windows operating system. Follow only step 1, and then open pgAdmin or postgres on web and click on file on the top nav. Click on reset layout, and finally reload the application. Whatever password you put should work. I used 1234.

Peter Mortensen's user avatar

answered Jun 27, 2022 at 11:12

Francis C.j Francis's user avatar

I didn’t manage to find the file pg_hba.conf in the folder C:\Program Files\PostgreSQL\14\data, because there is not a folder data at all.

I solved the problem by creating a new user using pgAdmin and gave it super system administrator rights.

Peter Mortensen's user avatar

answered Nov 23, 2022 at 15:31

Barabas's user avatar

BarabasBarabas

9208 silver badges20 bronze badges

Add the below line to your pg_hba.conf file. Which will be present in the installation directory of PostgreSQL

hostnossl    all          all            0.0.0.0/0  trust

It will start working.

Peter Mortensen's user avatar

answered Feb 26, 2021 at 10:47

Suresh S Y's user avatar

I either forgot or mistyped (during the installation) the password to the default user of PostgreSQL. I can’t seem to be able to run it, and I get the following error:

psql: FATAL:  password authentication failed for user "hisham"
hisham-agil: hisham$ psql

Is there a way to reset the password or how do I create a new user with superuser privileges?

I am new to PostgreSQL and just installed it for the first time. I am trying to use it with Ruby on Rails and I am running Mac OS X v10.7 (Lion).

Peter Mortensen's user avatar

asked Jun 1, 2012 at 7:14

hilarl's user avatar

1

  1. Find the file pg_hba.conf. It may be located, for example, in /etc/postgresql-9.1/pg_hba.conf.

    cd /etc/postgresql-9.1/

  2. Back it up

    cp pg_hba.conf pg_hba.conf-backup

  3. Place the following line (as either the first uncommented line, or as the only one):

    For all occurrence of below (local and host) , except replication
    section if you don’t have any it has to be changed as follow ,no MD5
    or Peer authentication should be present.

    local all all trust

  4. Restart your PostgreSQL server (e.g., on Linux:)

    sudo /etc/init.d/postgresql restart

    If the service (daemon) doesn’t start reporting in log file:

    local connections are not supported by this build

    you should change

    local all all trust

    to

    host all all 127.0.0.1/32 trust

  5. You can now connect as any user. Connect as the superuser postgres (note, the superuser name may be different in your installation. In some systems it is called pgsql, for example.)

    psql -U postgres

    or

    psql -h 127.0.0.1 -U postgres

    (note that with the first command you will not always be connected with local host)

  6. Reset the password (‘replace my_user_name with postgres since you are resetting the postgres user)

    ALTER USER my_user_name with password 'my_secure_password';

  7. Restore the old pg_hba.conf file as it is very dangerous to keep around

    cp pg_hba.conf-backup pg_hba.conf

  8. Restart the server, in order to run with the safe pg_hba.conf file

    sudo /etc/init.d/postgresql restart

Further reading about that pg_hba file: 19.1. The pg_hba.conf File (official documentation)

Peter Mortensen's user avatar

answered Jun 1, 2012 at 7:42

Arsen7's user avatar

Arsen7Arsen7

12.5k2 gold badges43 silver badges60 bronze badges

19

When connecting to PostgreSQL from the command line, don’t forget to add -h localhost as a command line parameter. If not, PostgreSQL will try to connect using PEER authentication mode.

The below shows a reset of the password, a failed login with PEER authentication and a successful login using a TCP connection.

# sudo -u postgres psql

could not change directory to "/root"
psql (9.1.11)
Type "help" for help.

postgres=# \password
Enter new password:
Enter it again:
postgres=# \q

Failing:

# psql -U postgres -W

Password for user postgres:
psql: FATAL:  Peer authentication failed for user "postgres"

Working with -h localhost:

# psql -U postgres -W  -h localhost

Password for user postgres:
psql (9.1.11)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.

postgres=#

Peter Mortensen's user avatar

answered Feb 2, 2014 at 10:21

SaeX's user avatar

SaeXSaeX

17.3k16 gold badges77 silver badges97 bronze badges

1

The pg_hba.conf (C:\Program Files\PostgreSQL\9.3\data) file has changed since these answers were given. What worked for me, in Windows, was to open the file and change the METHOD from md5 to trust:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust

Then, using pgAdmin III, I logged in without using a password and changed user postgres‘s password by going to menu FileChange Password.

Peter Mortensen's user avatar

answered Sep 19, 2014 at 22:26

SaiyanGirl's user avatar

SaiyanGirlSaiyanGirl

16.4k11 gold badges41 silver badges57 bronze badges

6

For Windows (what has helped me):

This is the document I am referring to: How can I reset a PostgreSQL password?

  1. Open your cmd and go to C:\Program Files\PostgreSQL\12\data.
    This is usually the right path. You might have it stored somewhere else. Note that, if you have a different PostgreSQL version, there will be a different number. That doesn’t matter.

  2. Find a pg_hba.conf file and copy it to somewhere else (that way you will have an unmodified version of this file, so you will be able to look at it after we make some changes)

  3. Open the pg_hba.conf file (not the backup, but the original)

  4. Find the multiple lines that start with host near the bottom of the file:

    host    all             all             127.0.0.1/32            md5
    
    host    all             all             ::1/128                 md5
    
    host    replication     all             127.0.0.1/32            md5
    
    host    replication     all             ::1/128                 md5
    
  5. Replace md5 with trust:

    host    all             all             127.0.0.1/32            trust
    
    host    all             all             ::1/128                 trust
    
    host    replication     all             127.0.0.1/32            trust
    
    host    replication     all             ::1/128                 trust
    
  6. Close this file

  7. Go to your search bar on windows and open Services app. Find postgres and restart it.

    Picture of services app

  8. Write cd.. in cmd and then cd bin. Your path should be C:\Program Files\PostgreSQL\12\bin

  9. Enter: psql -U postgres -h localhost

  10. Enter: ALTER USER postgres with password '<your new password>';Make sure that you include ; at the end
    “ALTER ROLE” should be displayed as an indication that the previous line was executed successfully

  11. Open original pg_hba.conf file and change back from trust to md5

  12. Restart the server with Services app as before

Peter Mortensen's user avatar

answered Nov 15, 2020 at 22:14

Vito Farina's user avatar

Vito FarinaVito Farina

2713 silver badges2 bronze badges

1

I was just having this problem on Windows 10 and the issue in my case was that I was just running psql and it was defaulting to trying to log in with my Windows username («Nathan»), but there was no PostgreSQL user with that name, and it wasn’t telling me that.

So the solution was to run psql -U postgres rather than just psql, and then the password I entered at installation worked.

answered Jun 26, 2019 at 21:29

Nathan Wailes's user avatar

Nathan WailesNathan Wailes

10k7 gold badges59 silver badges98 bronze badges

0

  1. Edit the file /etc/postgresql/<version>/main/pg_hba.conf and find the following line:

    local  all  postgres  md5
    
  2. Edit the line and change md5 at the end to trust and save the file

  3. Reload the postgresql service

    sudo service postgresql reload
    
  4. This will load the configuration files. Now you can modify the postgres user by logging into the psql shell

    psql -U postgres
    
  5. Update the postgres user’s password

    alter user postgres with password 'secure-passwd-here';
    
  6. Edit the file /etc/postgresql/<version>/main/pg_hba.conf and change trust back to md5 and save the file

  7. Reload the postgresql service

    sudo service postgresql reload
    
  8. Verify that the password change is working

    psql -U postgres -W
    

Peter Mortensen's user avatar

answered Aug 17, 2017 at 2:55

Ray Hunter's user avatar

Ray HunterRay Hunter

15.2k5 gold badges53 silver badges51 bronze badges

2

Just a note: On Linux, you can simply run sudo su - postgres to become the postgres user and from there change what is required using psql.

Peter Mortensen's user avatar

answered Mar 12, 2018 at 12:58

Daniel's user avatar

DanielDaniel

1991 silver badge4 bronze badges

1

For a Windows user for the latest PostgreSQL version (greater than 10):

Go to your PostgreSQL installation location, and search for pg_hba.conf, you will find it in ..\postgres\data\pg_hba.conf.

Open that file with Notepad, and find this line:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
#..

Change the method from *md5* to *trust*:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust
# ...

Now go to your SQL shell (PSQL) and leave everything blank,

Server [localhost]:
Database [postgres]:
Port [8000]:
Username [postgres]:

It will not ask for a password this time, and you will be logged in,

Now run this line:

  `ALTER USER yourusername WITH SUPERUSER`

Now you can leave the shell with \q.

Again, go to the file pg_hba.conf and change METHOD from trust to md5 again, and save it.

Now log in with your new user and password, and you can check \du for its attributes.

Peter Mortensen's user avatar

answered Feb 3, 2019 at 13:40

Bidhan Majhi's user avatar

Bidhan MajhiBidhan Majhi

1,3201 gold badge12 silver badges25 bronze badges

If you are running PostgreSQL on macOS, try these:

1. Edit the pg_hba.conf file

sudo vi /Library/PostgreSQL/9.2/data/pg_hba.conf
and Change the «md5» method for all users to «trust» near the bottom of the file

2. Find the name of the postgres service

ls /Library/LaunchDaemons
Look for postgresql

3. Restart the postgresql service

sudo launchctl stop com.edb.launchd.postgresql-9.2

sudo launchctl start com.edb.launchd.postgresql-9.2 (com.edb.launchd.postgresql-9.2 should be name postgresql service from step 3)

4. Start a psql session as postgres
psql -U postgres
(shouldn’t ask for password because of ‘trust’ setting)

5. Reset password in the psql session by typing:

    ALTER USER postgres with password 'secure-new-password';

6. Edit the pg_hba.conf file
Switch it back to ‘md5’

8. Restart services again

Sostene MUNEZERO BAGIRA's user avatar

answered Mar 16, 2020 at 15:22

David's user avatar

DavidDavid

3,86333 silver badges36 bronze badges

For a Windows installation, a Windows user is created. And «psql» uses this user for connection to the port. If you change the PostgreSQL user’s password, it won’t change the Windows one.
The command line just below works only if you have access to the command line.

Instead, you could use the Windows GUI application «c:\Windows\system32\lusrmgr.exe». This application manages users created by Windows. So you can now modify the password.

Peter Mortensen's user avatar

answered Mar 21, 2017 at 15:31

cpunky's user avatar

2

I did this to resolve the same problem:

Open the pg_hba.conf file with the gedit editor from the terminal:

sudo gedit /etc/postgresql/9.5/main/pg_hba.conf

It will ask for a password. Enter your admin login password.
This will open gedit with the file. Paste the following line:

host  all   all  127.0.0.1/32  trust
just below -

# Database administrative login by Unix domain socket

Save and close it.

Close the terminal, open it again and run this command:

psql -U postgres

You will now enter the psql console.

Now change the password by entering this:

ALTER USER [your preferred user name] with password '[desired password]';

If it says the user does not exist then instead of ALTER, use CREATE.

Lastly, remove that certain line you pasted in pg_hba and save it.

Peter Mortensen's user avatar

answered Nov 14, 2017 at 12:08

Taufiq Rahman's user avatar

Taufiq RahmanTaufiq Rahman

5,6302 gold badges37 silver badges44 bronze badges

sudo -u postgres psql

ALTER USER user_name WITH PASSWORD 'new_password';

desertnaut's user avatar

desertnaut

57.9k27 gold badges140 silver badges167 bronze badges

answered May 21 at 11:20

sina adibfar's user avatar

1

If you are on Windows you can just run

net user postgres postgres

And log in in PostgreSQL with postgres/postgres as the user/password.

Peter Mortensen's user avatar

answered Jun 7, 2016 at 16:36

ivofernandes's user avatar

0

Follow step 1 on the best answer.

Here is my addition if you use the Windows operating system. Follow only step 1, and then open pgAdmin or postgres on web and click on file on the top nav. Click on reset layout, and finally reload the application. Whatever password you put should work. I used 1234.

Peter Mortensen's user avatar

answered Jun 27, 2022 at 11:12

Francis C.j Francis's user avatar

I didn’t manage to find the file pg_hba.conf in the folder C:\Program Files\PostgreSQL\14\data, because there is not a folder data at all.

I solved the problem by creating a new user using pgAdmin and gave it super system administrator rights.

Peter Mortensen's user avatar

answered Nov 23, 2022 at 15:31

Barabas's user avatar

BarabasBarabas

9208 silver badges20 bronze badges

Add the below line to your pg_hba.conf file. Which will be present in the installation directory of PostgreSQL

hostnossl    all          all            0.0.0.0/0  trust

It will start working.

Peter Mortensen's user avatar

answered Feb 26, 2021 at 10:47

Suresh S Y's user avatar

Забыли пароль учетной записи postgres в PostgreSQL? Выполнить сброс не сложно. Для этого необходимо выполнить пару манипуляций.

1. Правим файл pg_hba.conf

Находим файл в папке Data директории установки PostgreSQL. В Windows путь выглядит примерно так c:\Program Files\PostgreSQL\9.2.4-1.1C\data\

В этом файле нужно найти такие строчки

# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 0.0.0.0/0 md5
# IPv6 local connections:
host all all ::1/128 md5

Меняем md5 на trust.

2. Удаляем файл pgpass.conf

В Windows этот файл находится в c:\Users\Administrator\AppData\Roaming\postgresql\

Здесь хранится старый пароль от PostgreSQL. Простое изменение хранимого здесь пароля мне не помогло. Поэтому я его просто удалил.

3. Меняем пароль в pgAdmin

Запускаем pgAdmin и нам предлагается ввести пароль. Если отметить галочку сохранить, то пароль будет сохранен в  pgpass.conf и больше программой запрашиваться не будет.

Чтобы обеспечить безопасность использования паролей необходимо вернуть алгоритм шифрования md5. Для этого в файле pg_hba.conf параметр trust обратно меняем на md5.

Для подключения на локальном компьютере к PostgreSQL с помощью psql, pg_dump в локальных адресах  IPv4 127.0.0.1/32 и IPv6 ::1/128 значение trust нужно оставить.

  • #1

Забыли пароль учетной записи postgres в PostgreSQL? Выполнить сброс не сложно. Для этого необходимо выполнить пару манипуляций. Останавливаем службу Postgres в службах windows. Переходим в каталог C:\Program Files\PostgreSQL\9.5\data и правим там файл pg_hba.conf:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
host    replication     all             127.0.0.1/32            trust
host    replication     all             ::1/128                 trust

Меняем md5 на trust.

Удаляем файл pgpass.conf. В Windows этот файл находится в С:\Users\Administrator\AppData\Roaming\postgresql\. Здесь хранится старый пароль от PostgreSQL.

Запускаем службу Postgres.
Запускаем cmd и вводим там команду:

В командной строке PG, которая появляется:

ALTER USER Postgres WITH PASSWORD '<newpassword>';

Сохраните это, набрав wq enter, чтобы выйти из запроса PG
Если возникает ошибка при вводе команды, что команда не определена добавляем путь в path C:\Program Files\PostgreSQL\9.5\bin
Возможно, вы захотите вернуться к изменению MD5 → Trust позже в pg_hba.conf.
Если изменения не сработали, тогда еще раз перезапустите службу Postgres и можете заходить под новым паролем.

Забыли пароль учетной записи postgres в PostgreSQL? Выполнить сброс не сложно. Для этого необходимо выполнить пару манипуляций.

1. Правим файл pg_hba.conf

Находим файл в папке Data директории установки PostgreSQL. В Windows путь выглядит примерно так c:\Program Files\PostgreSQL\9.2.4-1.1C\data\

В этом файле нужно найти такие строчки

# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 0.0.0.0/0 md5
# IPv6 local connections:
host all all ::1/128 md5

Меняем md5 на trust.

2. Удаляем файл pgpass.conf

В Windows этот файл находится в c:\Users\Administrator\AppData\Roaming\postgresql\

Здесь хранится старый пароль от PostgreSQL. Простое изменение хранимого здесь пароля мне не помогло. Поэтому я его просто удалил.

3. Меняем пароль в pgAdmin

Запускаем pgAdmin и нам предлагается ввести пароль. Если отметить галочку сохранить, то пароль будет сохранен в  pgpass.conf и больше программой запрашиваться не будет.

Чтобы обеспечить безопасность использования паролей необходимо вернуть алгоритм шифрования md5. Для этого в файле pg_hba.conf параметр trust обратно меняем на md5.

Для подключения на локальном компьютере к PostgreSQL с помощью psql, pg_dump в локальных адресах  IPv4 127.0.0.1/32 и IPv6 ::1/128 значение trust нужно оставить.

Спасибо софт-сетап

Join @AdmNtsRu on Telegram

Смотрите также:

  • Как сбросить пароль microsoft на windows 10
  • Как сбросить параметры экрана windows 10
  • Как сбросить параметры мыши на windows 10
  • Как сбросить параметры адаптера беспроводной сети на ноутбуке windows 7
  • Как сбросить панель задач windows 10 по умолчанию