Adminer PostgreSQL Admin Tool

The purpose of this page is to document a quick (2 hour) dive in to replacing phppgadmin with adminer. Results: Adminer does not have the tools for PostgreSQL that is does for MySQL. Example: Adminer does not list PostgreSQL functions. Here was the script on 16.04 to install and test:

ubuntu@ip-xx-xx-xx-xx:~$ history
 1 sudo apt-get update
 2 sudo apt-get install --yes postgresql postgresql-contrib php-pgsql
 3 sudo apt-get install --yes apache2 apache2-bin apache2-data apache2-utils libapache2-mod-php libapache2-mod-php7.0 libapr1 libaprutil1 libaprutil1-ldap liblua5.1-0 php7.0-cli php7.0-json php7.0-opcache php7.0-readline
 4 sudo mkdir /usr/share/adminer
 5 sudo wget "https://www.adminer.org/latest.php" -O /usr/share/adminer/latest.php
 6 sudo ln -s /usr/share/adminer/latest.php /usr/share/adminer/adminer.php
 7 echo "Alias /adminer.php /usr/share/adminer/adminer.php" | sudo tee /etc/apache2/conf-available/adminer.conf
 8 sudo a2enconf adminer.conf
 9 sudo service apache2 restart
11 wget https://raw.githubusercontent.com/devrimgunduz/pagila/master/pagila-schema.sql
13 wget https://raw.githubusercontent.com/devrimgunduz/pagila/master/pagila-insert-data.sql
 14 sudo -u postgres psql -c "create user yoadmin with password 'yo1016';"
14.5 sudo -u postgres psql -c "alter useryoadmin with SUPERUSER;"
 15 sudo -u postgres createdb test
 16 sudo -u postgres psql -c "grant all privileges on database test to yoadmin ;"
 17 sudo -u postgres psql -d test -f pagila-schema.sql 
 18 sudo -u postgres psql -d test -f pagila-insert-data.sql 
 19 history
 20 sudo sed -i '$ a\host all all 0.0.0.0/0 md5' /etc/postgresql/9.5/main/pg_hba.conf
 21 sudo sed -i 's/local all all peer/local all all md5/' /etc/postgresql/9.5/main/pg_hba.conf
 22 sudo sed -i '$ a\listen_addresses = '"'"'*'"'"' # chuboe '`date +%Y%m%d` /etc/postgresql/9.5/main/postgresql.conf
 23 sudo service postgresql restart