PGADMIN 4 CONNECT TO DATABASE HOW TO

Though this method of connecting would work with other modes of deployment as well, for simplicity purpose and to avoid and complexities in connecting to the database instance that may arise from using a different mode of deployment, we are using the Single Server mode for creating a new instance of Azure Database for PostgreSQL. Navigate to this service on the Azure portal and create an instance of the database using the Single Server deployment model.

It is assumed that one has access to an Azure account with the required privileges to administer Azure Database for PostgreSQL server service. We intend to connect to an instance of Azure Database for PostgreSQL using pgAdmin, so the obvious pre-requisite to perform this exercise is creating an instance of the database as well as installing pgAdmin on a local workstation.

PGADMIN 4 CONNECT TO DATABASE HOW TO

Let’s go ahead and see how to connect to instances of Azure Database for PostgreSQL using the pgAdmin tool. One of the reasons possibly is since the most popular tool that is already used by PostgreSQL users for on-premise or cloud-hosted deployment is pgAdmin, users would prefer to continue using the same familiar tool to operate on instances of Azure Database for PostgreSQL on the Azure platform too. But there’s no specific tooling offering from Azure to operate on this database. Azure’s offering of PostgreSQL database on the Azure platform is Azure Database for PostgreSQL server. Likewise, the PostgreSQL database is one such open-source database type and one of the most popular management tools to operate on this database is pgAdmin. Almost every type of user persona connects to SQL Server instances on-premises or on the cloud using SSMS to perform operations suited for their role. For example, one of the most popular management and operational tool for SQL Server is SQL Server Management Studio (SSMS). In this article, we will show how to connect to instances of Azure Database for PostgreSQL servers using the pgAdmin tool installed locally on a user’s workstation.Įvery type of database has a community of data tools that facilitates management and operations on the database instances.

Pgadmin 4 connect to database