![how to create database in pgadmin 4 how to create database in pgadmin 4](https://www.tecmint.com/wp-content/uploads/2020/08/pg-database-server-connected-successfully.png)
Once you are done filling in those fields go ahead and click on the second tab titled Connection. The information can be brought up in the interface later and can help you remember facts about this server.
![how to create database in pgadmin 4 how to create database in pgadmin 4](https://access.crunchydata.com/documentation/pgadmin4/3.2/images/server_general.png)
In the comment field you can put in some information about this server connection. You could call it monkey if you want - it doesn't require any relation to a name in the real world.įor today's exercise let's name it "Workshop" This name represents the name YOU want to use to identify this PostgreSQL server in the PgAdmin interface. On the general tab, the only field required is Name. While there are quite a few boxes and tabs in this dialog, only a few of them are actually required to create a new server in PgAdmin. Go ahead and click server to bring up the new create server dialog. In our case since we are only managing one server: Server groups is just a logical organization in the PgAdmin interface. If you are going to manage and interact with a lot of PostgreSQL servers then you might want to create server groups such as testing vs production. This will then show server group and server. When you right click on the icon you should see a list of options. Let's start by doing the right click option because it will give us more flexibility. Right click on the Servers icon in the top left of the left navigation panel.Click on the "Add New Server" butting in the middle of the screen.Before we can do anything meaningful we need to connect to a PostgreSQL server. You should be seeing a screen that looks like this:
#HOW TO CREATE DATABASE IN PGADMIN 4 PASSWORD#
To login using username admin and password password. You may have to wait a few seconds while the PGAdmin4 interface gets rendered. Go ahead and click that tab which should spawn a new browser window or tab. If you look at the second tab in our learning interface it says PgAdmin4.