$ sudo curl | sudo apt-key addĪdd pgAdmin 4 APT repository. Import the repository PGP signing key for pgAdmin.
PGADMIN 4 CONNECT TO DATABASE INSTALL
Install all required dependencies for pgAdmin 4 installation. Restart the PostgreSQL Database Server service to ensure the changes are saved. $ sudo nano /etc/postgresql/*/main/pg_hba.confĪt the end of the file add the following lines and save the file. To listen to all IP addresses, change the line to the below code and save the file. $ sudo nano /etc/postgresql/*/main/nfįind the following line. These files are located in the /etc/postgresql/*/main directory. We should edit the config files nf and pg_hba.conf to allow for remote connection. $ exitĭefault PostgreSQL config only allow connection to localhost (or 127.0.0.1) interface. Return to your non-root sudo user account. GRANT ALL PRIVILEGES ON DATABASE testdb to pgadmin Grant all the privileges on the testdb database to the user pgadmin. ALTER USER pgadmin WITH ENCRYPTED password 'secure_password' Ĭreate a database named testdb and set the owner to pgadmin. Set a secure password for the user pgadmin by changing the value of secure_password. $ su - postgresĬreate a new database user named pgadmin. $ sudo systemctl start postgresqlĬhange the default PostgreSQL password. $ sudo apt install postgresql-12 postgresql-client-12 -yĮnable the database server to start automatically on a reboot. Then, install PostgreSQL database server. $ sudo sh -c 'echo "deb `lsb_release -cs`-pgdg main" > /etc/apt//pgdg.list'
$ wget -quiet -O - | sudo apt-key add -Īdd PostgreSQL APT repository. Import the repository PGP signing key for PostgreSQL. Install and Configure PostgreSQL Database Server
This guide will take you through installing pgAdmin for PostgreSQL server on Ubuntu Linux. It includes a graphical administration interface, an SQL query tool, a procedural code debugger, and more other tools.
PGADMIN 4 CONNECT TO DATABASE SOFTWARE
PgAdmin is an open-source software project for administration and management of PostgreSQL database server. Are we missing a guide for your target system? Request one, or submit your own! Introduction
0 kommentar(er)
