In this article, we will see how to reset password for user in Azure PostgreSQL server.
We can reset password for a user in Azure PostgreSQL same as do for standard PostgreSQL server. We have two methods:
1. GUI i.e. using pgadmin tool
2. By running alter user/role command.
Continue reading How to reset password for user in Azure PostgreSQL server
In this article, we will see how to find list of users in Azure PostgreSQL. We can get list of users by querying against pg_user view and by expanding Login/Role Groups in pgadmin tool.
Find list of users in Azure PostgreSQL: Continue reading How to find list of users in Azure PostgreSQL
In this article, we will see how to create user in Azure PostgreSQL server.
We are going to create user in Azure MySQL server by using two ways.
1. Using GUI methods.
2. Using Create user statement on psql tool or pgadmin tool.
In this article, we will see the solution for error “FATAL: password authentication failed for user “postgres””.
1. Reason is the user postgres has no DB password set on Ubuntu by default. That means, that you can login to that account only by using the postgres OS user account.
Continue reading FATAL: password authentication failed for user “postgres”
In this article, we will see how to install PostgreSQL 13 on Redhat.
PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
1. Install the repository
dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
2. Disable the built-in PostgreSQL module:
dnf -qy module disable postgresql
3. Install PostgreSQL 13 version using below command.
dnf install -y postgresql13-server
4. Now initialize database b running below command.
/usr/pgsql-13/bin/postgresql-13-setup initdb
5. Enable the PostgreSQL service.
systemctl enable postgresql-13
6. Start the PostgreSQL Server on Redhat or CentOS
systemctl start postgresql-13
7. Check the status PostgreSQL on Regdhat or CentOS
systemctl status postgresql-13
1. Switch to postgres user.
sudo su - postgres
2. Then connect to the PostgreSQL server using psql tool.
psql
3. Now change the password for user “postgres”
alter user postgres with password 'admin@123';
So, in this article, we have explained How to install PostgreSQL 13 on Redhat step by step.
In this article, we will see how to change PostgreSQL User Password with syntax and examples. We can change PostgreSQL User password by using alter database command.
Syntax to change PostgreSQL User/Role password:
alter user user_name with password 'NewPASSWORD'
1. Create User in PostgreSQL server.
CREATE USER karunakar with password 'karunakar@123';
2. Now change the password of PostgreSQL user using below command.
alter user karunakar with password 'admin@123';
With these steps we can change PostgreSQL User password in PgAdmin.