phpPgAdmin6 Installation Guide
-----------------------------

1. Unpack your download

   If you've downloaded a tar.gz package, execute from a terminal:

   gunzip phpPgAdmin6-*.tar.gz
   tar -xvf phpPgAdmin6-*.tar

   Else, if you've downloaded a tar.bz2 package, execute from a terminal: 

   bunzip2 phpPgAdmin6-*.tar.bz2
   tar -xvf phpPgAdmin6-*.tar

   Else, if you've downloaded a zip package, execute from a terminal:

   unzip phpPgAdmin6-*.zip

2. Configure phpPgAdmin6

   edit phpPgAdmin6/conf/config.inc.php

   If you mess up the configuration file, you can recover it from the
   config.inc.php-dist file.

3. If you run your PHP installation in safe mode, in order that the database
   dump feature can work correctly, you need to set the 'safe_mode_allowed_env_vars'
   php.ini variable to include the PGPASSWORD and PGUSER environmental variables
   and the safe_mode_exec_dir to include /usr/bin (or wherever the pg_dump
   binaries are found).
   
   	eg. safe_mode_allowed_env_vars = PHP_,PG
   	    safe_mode_exec_dir = /usr/bin
   
   Given that you usually don't want to allow everything in /usr/bin to
   be executed, you might want to copy the pg_dump and pg_dumpall utilities
   to a directory by themselves.
   
   Also, you will need to ensure that your 'pg_dump' and 'pg_dumpall' utilities
   are executable by the PHP process, if you want dump support in phpPgAdmin6.

   Lastly, if you run phpPgAdmin6 in safe mode, very long running imports,
   exports and transactions may time out and be aborted.

4. Ensure the statistics collector is enabled in PostgreSQL.  phpPgAdmin6 will 
   display table, index performance, and usage statistics if you have enabled
   the PostgreSQL statistics collector.  While this is normally enabled by 
   default, to ensure it is running, make sure the following lines in your 
   postgresql.conf are uncommented: 

    track_activities
    track_counts 

5. Browse to the phpPgAdmin6 installation using a web browser.  You might
   need cookies enabled for phpPgAdmin6 to work.

6. IMPORTANT - SECURITY

   PostgreSQL by default does not require you to use a password to log in.
   We STRONGLY recommend that you enable md5 passwords for local connections
   in your pg_hba.conf, and set a password for the default superuser account.

   Due to the large number of phpPgAdmin6 installations that have not set
   passwords on local connections, there is now a configuration file
   option called 'extra_login_security', which is TRUE by default.  While
   this option is enabled, you will be unable to log in to phpPgAdmin6 as
   the 'root', 'administrator', 'pgsql' or 'postgres' users and empty passwords
   will not work.
   
   Once you are certain you have properly secured your database server, you
   can then disable 'extra_login_security' so that you can log in as your
   database administrator using the administrator password.