Horje
reset postgres password windows Code Example
How to reset forgotten postgresql password
# 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
reset postgres password windows
Backup the pg_hba.conf file by copying it.
Edit the pg_dba.conf, change `METHOD` to 'trust'
Restart the PostgreSQL server.
psql -U postgres.
ALTER USER postgres WITH PASSWORD 'new_password';
Restore the pg_dba.conf file.
Restart the PostgreSQL server.
how to reset postgres password
sudo sed -ibak 's/^\([^#]*\)md5/\1trust/g' /opt/bitnami/postgresql/conf/pg_hba.conf
sudo -u postgres pg_ctl reload
reset password postgres ubuntu
\password sde
reset postgresql password windows
pg_ctl -D "C:\Program Files\PostgreSQL\12\data" restart
Langage de code :  JavaScript  ( javascript )




Shell

Related
linux check apt repositories Code Example linux check apt repositories Code Example
tcpdump get dhcp packets Code Example tcpdump get dhcp packets Code Example
install typescript  in node project Code Example install typescript in node project Code Example
brew mongodb: unknown version :mountain_lion Code Example brew mongodb: unknown version :mountain_lion Code Example
install keras Code Example install keras Code Example

Type:
Code Example
Category:
Coding
Sub Category:
Code Example
Uploaded by:
Admin
Views:
8