====== PostgreSQL 8.1 + phppgadmin on Debian mini-HOWTO ======

----

The default installation of PostgreSQL in Debian etch is not yet well configured, and so not suitable to work with phppgadmin, too. This simple mini-HOWTO will guide you though those critical but minor procedures, which will let all of your PostgreSQL functioning within 5 min :)

===== Install required packages =====

  apt-get update
  apt-get install postgresql-8.1 postgresql-client-8.1
  postgresql-doc-8.1 phppgadmin php5-pgsql libapache2-mod-php5

===== First test with PostgreSQL =====

Login pgsql console as user "postgres":

  localhost:~# su
  localhost:~# su - postgres
  postgres@localhost:~$ psql template1
  Welcome to psql 8.1.9, the PostgreSQL interactive terminal.
  
  Type:  \copyright for distribution terms
         \h for help with SQL commands
         \? for help with psql commands
         \g or terminate with semicolon to execute query
         \q to quit
  
  template1=#

Update pgsql user "postgres" password (required by phppgadmin):

  template1=# ALTER USER postgres PASSWORD 'passwd';
  ALTER ROLE
  template1=# \q
  postgres@localhost:~$

Create pgsql user "root" with database "AL32UTF8", with basic login:

  localhost:~# su
  localhost:~# su - postgres
  postgres@localhost:~$ createuser -DRS root
  CREATE ROLE
  postgres@localhost:~$ createdb -O root AL32UTF8
  CREATE DATABASE
  postgres@localhost:~$ psql template1
  Welcome to psql 8.1.9, the PostgreSQL interactive terminal.
  
  Type:  \copyright for distribution terms
         \h for help with SQL commands
         \? for help with psql commands
         \g or terminate with semicolon to execute query
         \q to quit
  
  template1=# ALTER USER root PASSWORD 'passwd';
  ALTER ROLE
  template1=# \q
  postgres@localhost:~$ psql AL32UTF8
  Welcome to psql 8.1.9, the PostgreSQL interactive terminal.
  
  Type:  \copyright for distribution terms
         \h for help with SQL commands
         \? for help with psql commands
         \g or terminate with semicolon to execute query
         \q to quit
  
  AL32UTF8=# \q
  postgres@localhost:~$ exit
  logout
  localhost:~# psql AL32UTF8
  Password:
  Welcome to psql 8.1.9, the PostgreSQL interactive terminal.
  
  Type:  \copyright for distribution terms
         \h for help with SQL commands
         \? for help with psql commands
         \g or terminate with semicolon to execute query
         \q to quit
  
  AL32UTF8=> \q
  localhost:~#

===== Configure and working with phppgadmin =====

Edit /etc/phppgadmin/config.inc.php, change the following line from:

  $conf['extra_login_security'] = true;

into:

  $conf['extra_login_security'] = false;

in order to allow root/postgres user login from phppgadmin.

Create symbolic link for phppgadmin web access:

  localhost:~# ln -s /usr/share/phppgadmin /var/www/

Access http://localhost/phppgadmin, login as root or postgres, enjoy your newly installed PostgreSQL server :)

===== =====

[[http://edin.no-ip.com/content/postgresql-8-1-phppgadmin-debian-mini-howto|This page was shamelessly copied from here.]]