![]() Screen 5 - Filling in the fields for connecting to the database After filling in the fields, click the Save button (see Screen 5). Let's go to the Connection tab, fill in the fields Hostname / address (Host name / address) - localhost, Maintenance database (Serving database) - serverspace, Username (User name) - serverspace, Password (Password) - specified earlier on the command line. Stage 5 – PostgreSQL user configurationįrom the account of the previously created user, you need to connect to the database:ĪLTER USER serverspace PASSWORD by pressing Ctrl C or \q:Īdd a new server to the pgAdmin 4 web interface using the Add New Server tool (see Screen 3). Screen 2 - pgAdmin control panelĪfter gaining access to pgAdmin, let's make a small change in the configuration file to connect to the PostgreSQL database. The standard window stores various features and tools from adding a new server to the support community. Successful authorization is shown to us on the main page of the pgAdmin web interface (see Screen 2). On the local machine, launch a web browser and in the address bar specify the address of the host where pgAdmin is deployed When authorizing, we will specify the e-mail, password and perform authorization by clicking on the Login button (See Screen 1) Screen 1 - Access to pgAdmin The command must be executed from the virtual space my_env and the output must not contain errors related to libraries. Listening at: unix:/tmp/pgadmin4.sock (6338) Updating package indexes first, let's use the built-in apt utility. Stage 1 – Deploying pgAdmin and downloading dependencies Virtual environment deployed in Python.Installed PostgreSQL, you need to add a new user, as well as database to connect pgAdmin to our database. ![]() ![]()
0 Comments
Leave a Reply. |