![]() If you already have Apache and PHP installed, you can skip this step.Īpt install apache2 php libapache2-mod-php -y We can also configure phpPgAdmin to only show databases owned by the logged-in user, modify this line. To allow login using user root or postgres, we need to modify the phpPgAdmin configuration. Now, execute following command to install the phppgadmin. GRANT ALL PRIVILEGES ON DATABASE pgadmindb TO sajid Login into postgres user account and type psql to enter the PostgreSQL shell.ĬREATE USER sajid WITH PASSWORD 'mydbpassword' You will need to set up a database and create a user for PhpPgAdmin. You can access the PostgreSQL shell using user ‘postgres’. Step # 4: Setup a Database for PhpPgAdmin If you want to access from another network, we need to modify the configuration file to listen on all addresses or a specific address, this time we will make it listen on all addresses. By default, the PostgreSQL server will listen on localhost. So, the PostgreSQL service will automatically be started after installation, you can check the status with this command: systemctl status postgresql Step # 3: Configure PostgreSQL. ![]() Now execute the following command to install the Postgre SQL server.Īpt install postgresql postgresql-client postgresql-client-common postgresql-common postgresql-contrib -y Step # 1: Update server and all install packages:įirst, make sure all the existing packages on your system are up to date. Root user or Sudo Privileged user account. PhpPgAdmin is a fully managed web-based administration tool for the PostgreSQL database server. ![]() It is a free and open-source database management system. PostgreSQL is powerful object-relational database systems. In this article, we will learn how to Install and configure PostgreSQL with phpPgAdmin on Ubuntu 20.04 LTS ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |