The pgAdmin app will attempt to connect to the server automatically, and the setting will be changed so the next time you open pgAdmin, you’ll be able to connect easily. Check the box next to Save password? to instruct pgAdmin to save the password for future use if you want.Use the Password field to provide a password that goes with the database user account you’re using.Use the Username field to specify the username assigned to the database to which you’re connecting.Use the Maintenance database field to specify the name of the database to which you want to connect.Enter the listener port number of the server host in the Port field.For example, this could be the IP address 1.2.3.4 or a server hostname, like. Enter the IP address or server hostname you wish to connect to.Use the fields in the Connection tab to configure a connection: When you’ve finished, click the Connection tab at the top. Proceed by giving the connection a name that you will remember, for example – it might say something like, my blog database, or ChemiCloud PostgreSQL. The first time you open pgAdmin, you need to set up the server so the app knows where to connect. For this tutorial, we are using pgAdmin 4 version 5.1. Data Page: At times, when we need to access data say Employee details, we need to get data from the database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |