Reset Postgress user password in PostgreSQL

-
Reset Postgress user password in PostgreSQL

Follow below steps to Reset password for Postgress user in PostgreSQL:

 Also follow other topics:

 Find the location of pg_hba.conf
# find / -name pg_hba*
/usr/local/pgsql/data/pg_hba.conf

# vi /usr/local/pgsql/data/pg_hba.conf

Add below parameter:
local   all             all                                     trust

Note: "trust" will allow all connection without prompting for password

Login to Postgres:
# psql -U postgres

postgres=#

Use below command to change password for postgress user:
postgres=# alter user postgres with password 'NEW_PASSWORD';

Check for database:
postgres=# \l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
(3 rows)

Exit from postgreSQL:
postgresl=# \q

Revert back the original configuration:
# vi /usr/local/pgsql/data/pg_hba.conf

Comment below parameter:
local   all             all                                     trust

or change as below:
local   all             all                                     password

Login to postgres:
# psql -U postgres
Password for user postgres: <New_Password>

psql (11.4)
Type "help" for help.

postgres=#

Check for database:
postgres=# \l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
(3 rows)

Exit from postgreSQL:
postgresl=# \q

Comments

Post a Comment

Popular posts from this blog

How to install glibc 2.14 on RHEL 6/ RHEL 7/ CentOS 7

-
  How to install glibc 2.14 on RHEL 6/ RHEL 7/ CentOS 7   Installing  glibs is very easy. This can be done by below 4steps. Step1:- Subscribe OS with RHEL   or Configure local repository for installing packages Step2:-  Check installed glibc package. # yum list glibc Available Packages glibc.i686                   2.17-307.el7.1                  @rhel-7-server-rpms glibc.x86_64                 2.17-307.el7.1                  @rhel-7-server-rpms Step3:- yum install glibc.x86_64 Step4:- Check installed glibc package. # yum list glibc Installed Packages glibc.x86_64           ...
Read more

Export and Import users/groups and OU in AD Server 2008 using LDIFDE command.

-
*** All the below commands are use in command prompt. Viewing LDIFDE general parameters Click Start, point to Programs, point to Accessories, and then click 1. Command Prompt. Using LDIFDE to import and export directory objects to Active Directory To Export All OU:- C:\> ldifde -f orissa.ldf -s WIN-MB9FF6Z1KLE -d "dc=testbed,dc=com" -p subtree -r "(objectCategory=organizationalUnit)" -l "cn,objectclass,ou" Connecting to "WIN-MB9FF6Z1KLE" Logging in as current user using SSPI Exporting directory to file orissa.ldf Searching for entries... Writing out entries...... 6 entries exported The command has completed successfully To Import   All OU Expect Default OU:- Edit the orissa.ldf and delete all default OUs. And use the command. C:\> ldifde -i -f orissa.ldf Connecting to "WIN-MB9FF6Z1KLE.testbed.com" Logging in as current user using SSPI Importing directory from file "ori...
Read more

How to Set Up and Configure latest yum repository on CentOS

-
Set Up and Configure latest yum repository on CentOS : We can upgrade CentOS easily by Setup Local Yum Repository for latest packages in CentOS 7 . Also visit Upgrade CentOS to latest version using yum update command also you can visit update CentOS packages using yum update command without upgrading to minor release for updating packages in CentOS. Some time we can’t find updated packages in default repository with CentOS. For that we can Set Up and Configure latest yum repository on CentOS using trick below. Set Up and Configure latest yum repository on CentOS: 5 Easy Steps Step 1: Visit CentOS package repository https://buildlogs.centos.org/ and http://mirror.centos.org/centos/ are the CentOS websites where all updated packages are available. Go to button of the site brows and locate your package where you can download CentOS packages. Using that directory we can create CentOS 7 yum repository . Step 2: Setup Local Yum Repository # cd /etc/yum.repo...
Read more