Installing PostgreSQL and Phppgadmin under Ubuntu

PostgreSQL is a powerful, high-performance object-relational database management system (ORDBMS) that uses the same licensing approach as BSD. PostgreSQL is great for large databases and has many advanced features. PostgreSQL supports many operating systems, including Linux,freebsd,solaris and Microsoft Windows.

Phppgadmin is a PHP-based Web application that manages the PostgreSQL database. Using Phppgadmin it is easy to create a database, create a role, and create a table in Postgres. Let's talk about the process of installing PostgreSQL and phppgadmin under Ubuntu.

pgbouncer in postgresql

First step: Installing PostgreSQL, Phppgadmin and Apache2

postgresql ui

sudo apt-get -y install postgresql postgresql-contrib phppgadmin

phppgadmin postgresql 11

Step Two: Configure PostgreSQL users

PostgreSQL uses user authentication and authorization similar to the UNIX permissions role. By default, PostgreSQL creates a new user named "Postgres" for Basic authentication. To use PostgreSQL, you need to log in to the "Postgres" account, which you can type by typing:

sudo -u postgres psql

Then change the password for the Postgres role:\p

postgresql tutorial pdf

Step Three: Configure Apache2

cd /etc/apache2/conf-available/
phppgadmin.confComment out #require local, add allow from all so that you can access it from your browser.

Fourth Step: Configure Phppgadmin

Edit File/etc/phppgadmin/config.inc.php:

cd /etc/phppgadmin/
config.inc.phpFind $conf [' extra_login_security '] = true; Modified to False.

postgresql varchar or text

You can use Postgres phppgadmin.

postgresql update inner join

Fifth step: Restart PostgreSQL and Apache2

systemctl restart postgresql
systemctl restart apache2

Sixth Step: Test Login

Browser input: http://localhost/phppgadmin/

postgresql synchronous_commit

Installing PostgreSQL and Phppgadmin under Ubuntu