PostgreSQL How-to Quick-Start with Database Creation on phpPgAdmin Web UI for GNU/Linux

May 29th, 2015 by thelinuxevangelist

phpPgAdmin Database Creation Quick-Start on Linux




The Linux Tutorial Shows You Step-by-Step How-to Getting-Started with PostgreSQL Database Creation by the phpPgAdmin Web UI on GNU+Linux Desktops/Server.

The phpPgAdmin Tutorial include Link to phpPgAdmin Initial Setup and Quick-Start for Linux Ubuntu/Debian Based systems.

phpPgAdmin is a web-based administration tool UI for PostgreSQL. It is perfect for PostgreSQL Database Administrators, Newbies, and Hosting services.




PostgreSQL is the most Advanced, open source object-relational database system.

PosgreSQL has a strong reputation for Reliability, Data Integrity, and Correctness.

phpPgAdmin is a web-based administration tool UI for PostgreSQL.
It is perfect for PostgreSQL Database Administrators, Newbies, and Hosting services.

Linux Ubuntu PostgreSQL Database Creation Quick-Start with PhpPgAdmin - Featured
  1. How-to Quick-Start with phpPgAdmin on Ubuntu/Debian Based OS’s:

    phpPgAdmin Quick-Start Guide
  2. Creating a Regular User for PostgreSQL Admin

    1. Amend the pg_hba.conf file:

    2. sudo nano /etc/postgresql/9.1/main/pg_hba.conf

      And Change “peer” to “md5” on the line concerning the user postgres as:

      local      all     postgres     peer md5

      Ctrl+x to Save & Exit from nano editor ;)

    3. Restart the PostgreSQL DB Server

      sudo /etc/init.d/postgresql restart
      (Here you can check it worked with psql -U postgres.)

    4. Create a PostgreSQL User having the same name as your:

    5. createuser -U postgres -d -e -E -l -P -r -s $(whoami)

      The options tell postgresql to create a user that can login, create databases, create new roles, is a superuser, and will have an encrypted password.
      The really important ones are -P -E, so that you’re asked to type the password that will be encrypted, and -d so that you can do a createdb.
      Beware of passwords : it will first ask you twice the new password (for the new user), repeated, and then once the postgres password (the one specified on step 2).

    6. Edit Again the pg_hba.conf file:

    7. Change “peer” to “md5” on the line concerning “all” other users Like:

      local      all     all     peer md5
    8. Restart the PostgreSQL DB Server

      sudo /etc/init.d/postgresql restart

    9. Check You can login without -U postgres:

      psql template1
      Ctrl+d to Exit from PostgreSQL CLI.

    Thanks to…

  3. Login on phpPgAdmin as Your User

    How-to Quick-Start to Administer PostgreSQL Databases with phpPgAdmin on Linux - phpPgAdmin Login

  4. Then You’ll be Able to Create & Manage New Databases with phpPgAdmin

    GNU/Linux PostgreSQL Admin Quick-Start with phpPgAdmin Web UI - Creating and Managing PostgreSQL Databases on phpPgAdmin Web UI

Tags: , , , , , , , , , , , , , , , , ,