PhpPgAdmin is a web based administration tool for PostgreSQL. You should use it if you don't want to manage your database from the command line. Plus it helps making large databases quickly.

Installation Instructions

Downloading phpPgAdmin

1. Go to http://phppgadmin.sourceforge.net/ to download phpPgAdmin
   (download: phpPgAdmin_2-4-2.tar.gz)

Installing phpPgAdmin

2. Log onto abstract.cs.washington.edu

   (note: we are using abstract since it has php support, host can be different as long as it has this)

3. If you do not have a 'www' folder in your home directory, make one. The 'www' folder is for all your website files on abstract.
   

   [user@abstract ~]$ mkdir www

4. Change directory into 'www'
   

   [user@abstract ~]$ cd www
   

5. Check present working directory
   

   [user@abstract ~]$ pwd

   Should be /www/homes/username/www
   
   
6. Upload phpPgAdmin_2-4-2.tar.gz into www folder
7. Unzip and untar phpPgAdmin_2-4-2.tar.gz
   

   [user@abstract ~]$ gunzip -cd phpPgAdmin_2-4-2.tar.gz | tar xvf -

   Configuring phpPgAdmin

8. Change directories into 'phpPgAdmin'
   

   [user@abstract ~]$ cd phpPgAdmin

9. Create configuration file from dist
   

   [user@abstract ~]$ cp config.inc.php-dist config.inc.php

10. Edit config.inc.php file
    
    • edit host to cubist, line 60
    • edit user to database username, line 64
    • edit password to database password, line 65

    [user@abstract ~]$ pico +60 config.inc.php

    • $cfgServers[1]['host'] = 'cubist.cs.washington.edu';
    • $cfgServers[1]['user'] = 'username';
    • $cfgServers[1]['password'] = 'password';

11. Save file and exit
    
12. Check to see if it is working, should link to login screen
    

    go to http://abstract.cs.washington.edu/~username/phpPgAdmin/index.php

Securing your database administration

13. Create .htaccess file to only allow uw cse students from your group

    [user@abstract ~]$ pico .htaccess

    file should be created in /www/homes/username/www/phpPgAdmin folder

14. Setup cse login, in .htaccess file type

    Authtype CSENetID
    require user user.1 user.2 ...

    where user.n is a member of your dev team

15. Check for web login credentials

    go back to http://abstract.cs.washington.edu/~username/phpPgAdmin/index.php

16. That's it. Everything should work now. Good Luck.