How to access BigAnimal using pgAdmin
In this article, we will see how to connect to BigAnimal Clusters using the pgAdmin tool installed on local machine.
First we can create BigAnimal Cluster. Once the Cluster is created, you will see the Cluster as shown below.
The next part is installing the pgAdmin tool. As of the draft of this article, the latest version of this tool is pgAdmin 4 v6.2. This tool can be freely installed on the local machine from here. As shown below. In this Article we install to windows operating system.
Connecting to BigAnimal with pgAdmin 4
After pgAdmin 4 v6.2 is installed, it now time to connect to BigAnimal Cluster that we created earlier. Once pgAdmin 4 v6.2 is installed, open the same and it would look as shown below. When the tool is opened the very first time, it will prompt to configure a master password, since this tool can save connections and credentials that may readily connect to a database instance.
Click on the Add New Server option from the quick links as shown above, which would bring up a dialog box as shown below. To access BigAnimal Cluster, we need to register the Cluster first. In the General tab, we need to provide a name for the server.
In the Connection tab, we need to provide the hostname or address. This is the server name of the Cluster that we created earlier, as shown below. The default port of Biganimal Cluster is 5432. The default maintenance database is edb_admin. Fill up these details as shown below. Provide the administrator credentials that you would have configured while creating the Cluster.
Open the SSL tab and you would find that the SSL mode is set to a value of “require”. Once done click on the Save button.
Once we click on the Save button, pgAdmin 4 v6.2 would immediately attempt to connect to the BigAnimal Cluster.
In this way, we can use the pgAdmin 4 v6.2 utility to connect to BigAnimal Cluster.