Install PostgreSQL on Debian or Ubuntu

PostgreSQL also known as Postgres, is a free and open-source

Install PostgreSQL on Debian or Ubuntu

PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. In 1996, the project was renamed to PostgreSQL to reflect its support for SQL. After a review in 2007, the development team decided to keep the name PostgreSQL. Source Wikipedia

Open Terminal / Login SSH Account

sudo apt install ca-certificates apt-transport-https curl
sudo wget -q https://packages.sury.org/php/apt.gpg -O- | apt-key add -
echo "deb https://packages.sury.org/php/ stretch main" | tee /etc/apt/sources.list.d/php.list

Don't forget Update and Upgrage

sudo apt update && upgrade -y

Install PostgreSQL and phpPgAdmin

sudo apt install php-mbstring php-pgsql libapache2-mod-php postgresql-9.6 phppgadmin

Enable PostgreSQL Service

sudo systemctl start postgresql.service
sudo systemctl enable postgresql.service
sudo systemctl status postgresql.service

Create Password PostgreSQL

su - postgres
> psql
> \password postgres
>\q
# logout;

Edit Config phpPgAdmin

sudo nano /etc/phppgadmin/config.inc.php
$conf['extra_login_security'] = true;
to
$conf['extra_login_security'] = false;

Open your web browser http://localhost/phppgadmin or http://your_ip/phppgadmin

Video Tutorial

Related Post

Install MariaDB on Debian or Ubuntu
Install FreeRadius PgSQL on Debian or Ubuntu
Install Webserver on Debian or Ubuntu
Install FreeRadius MySQL on Debian or Ubuntu
Enable SQLCounter FreeRadius

Comments

There are 0 comments on this post

Leave A Comment