Comments on How to Install PostgreSQL and phpPgAdmin on Ubuntu 18.04 LTS

Hi,

Kindly correct the spelling of this line "systemctl restart posqtgresql" to read "systemctl restart postgresql" so that the code can work well.

Thanks, it worked on Kubuntu 18.04.

Thanks for this. Works like charm.. I truly appreciate

Thank you, Muhammad Arul. Fantastically smooth-working implementation description!

i encountered this error: "unable to locate phppgadmin", when trying to install phppgadmin. Can you help me on this?

Same issue...

sudo apt-get install phppgadmin

Reading package lists... Done

Building dependency tree

Reading state information... Done

E: Unable to locate package phppgadmin

The package is definitely there, just installed it on Ubuntu 18.04. Probably you don't have all Ubuntu repositories (restricted + universe + multiverse) enabled. The /etc/apt/sources.list file on your server should contain this:

# deb cdrom:[Ubuntu-Server 18.04 LTS _Bionic Beaver_ - Release amd64 (20180425.1)]/ bionic main restricted

#deb cdrom:[Ubuntu-Server 18.04 LTS _Bionic Beaver_ - Release amd64 (20180425.1)]/ bionic main restricted

# See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to

# newer versions of the distribution.

deb http://de.archive.ubuntu.com/ubuntu/ bionic main restricted

# deb-src http://de.archive.ubuntu.com/ubuntu/ bionic main restricted

## Major bug fix updates produced after the final release of the

## distribution.

deb http://de.archive.ubuntu.com/ubuntu/ bionic-updates main restricted

# deb-src http://de.archive.ubuntu.com/ubuntu/ bionic-updates main restricted

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu

## team. Also, please note that software in universe WILL NOT receive any

## review or updates from the Ubuntu security team.

deb http://de.archive.ubuntu.com/ubuntu/ bionic universe

# deb-src http://de.archive.ubuntu.com/ubuntu/ bionic universe

deb http://de.archive.ubuntu.com/ubuntu/ bionic-updates universe

# deb-src http://de.archive.ubuntu.com/ubuntu/ bionic-updates universe

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu

## team, and may not be under a free licence. Please satisfy yourself as to

## your rights to use the software. Also, please note that software in

## multiverse WILL NOT receive any review or updates from the Ubuntu

## security team.

deb http://de.archive.ubuntu.com/ubuntu/ bionic multiverse

# deb-src http://de.archive.ubuntu.com/ubuntu/ bionic multiverse

deb http://de.archive.ubuntu.com/ubuntu/ bionic-updates multiverse

# deb-src http://de.archive.ubuntu.com/ubuntu/ bionic-updates multiverse

## N.B. software from this repository may not have been tested as

## extensively as that contained in the main release, although it includes

## newer versions of some applications which may provide useful features.

## Also, please note that software in backports WILL NOT receive any review

## or updates from the Ubuntu security team.

deb http://de.archive.ubuntu.com/ubuntu/ bionic-backports main restricted universe multiverse

# deb-src http://de.archive.ubuntu.com/ubuntu/ bionic-backports main restricted universe multiverse

## Uncomment the following two lines to add software from Canonical's

## 'partner' repository.

## This software is not part of Ubuntu, but is offered by Canonical and the

## respective vendors as a service to Ubuntu users.

# deb http://archive.canonical.com/ubuntu bionic partner

# deb-src http://archive.canonical.com/ubuntu bionic partner

deb http://security.ubuntu.com/ubuntu bionic-security main restricted

# deb-src http://security.ubuntu.com/ubuntu bionic-security main restricted

deb http://security.ubuntu.com/ubuntu bionic-security universe

# deb-src http://security.ubuntu.com/ubuntu bionic-security universe

deb http://security.ubuntu.com/ubuntu bionic-security multiverse

# deb-src http://security.ubuntu.com/ubuntu bionic-security multiverse

Thanks for this. There is a typo in line

Thanks! Fixed the typo.

These are quite clear instructions.

I followed them all and still get "Login disallowed for security reasons."  I checked the editing of the extra_login_security to false, and restarted postgresql and apache2 services twice.

Thanks for sharing the details for assisting me in installing PostgreSQL.

su - postgres

you cannot login as postgres user from default user login.previously you need run "sudo su" and enter your system password!!!

sudo apt -y install

The -y goes after 'install'

It worked for me, some initial hiccups and then I could trouble shoot my way. Thanks

Great help, worked like a charm. Really appreciate your effort writing this. Ubuntu 18.04

Hi guys!I can't conect postgres user on phppgadmin

a revised all topics

Thanks

worked well thank u!

hello, i want to ask something, how if i use tomcat as webserver and how i config it in this step https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-ubuntu-1804/#step-configure-apache-web-serveri use this tutorial to build tomcat webserver https://www.howtoforge.com/tutorial/how-to-install-and-configure-apache-tomcat-9-on-ubuntu-1804/hopefuly you answer, thanks for your attention before, regrads kautsar