In this article, we will see how to create database in Azure PostgreSQL Server.
Database is collection objects like tables, views, indexes, schemas, ….etc.
We are going to create a database in Azure PostgreSQL server by using following two methods.
1. Using CREATE DATABASE command.
2. Using GUI method using pgadmin tool.
Continue reading How to create database in Azure PostgreSQL Server
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.
PostgreSQL pgadmin error Unable to connect to Server:
FATAL: Invalid username specified. Please check the Username and retry connection.
The Username should be in
Continue reading PostgreSQL pgadmin error Unable to connect to Server
In this article, we will see how to connect to Azure PostgreSQL Server from pgadmin or psql.
1. Connect to Azure portal, then click on Azure PostgreSQL Server. From left menu click on connection security. Then, provide name for your firewall, IP address as show below. Then click on Save.
Continue reading How to connect to Azure PostgreSQL Server