Table of Contents


Using pgAdmin 3 you can import a database using the command line:

\i <database path>

You access the commandline through Plugins > Console.

Alternatively, you can of course use the bash shell as well:


(You also have the option to specify the user: psql -U PSQL_USER DATABASE_NAME < DUMP_FILE)

If you're having problems with connecting your Moodle to your database you should consider adding the port of the database behind the host string in the config.php, like this:

$CFG→host = 'localhost:5433'


Just like MySQL has phpmyadmin, PostgreSQL has its own web-based tool: phpPgAdmin. Under Ubuntu, installing it should be easy:

sudo apt-get install phppgadmin

The tool should now be available under http://localhost/phpPgAdmin. You might run into trouble however, if your php settings display too many notices and warnings. To suppress this, edit /usr/share/phppgadmin/conf/ Add this code to the top of the file:

// per Ubuntu bug 614481
error_reporting(E_ALL & ~E_DEPRECATED);

… and you should be good to go.


Use schemaSpy to graph tables: (not just for PostgreSQL; a lot of other databases are supported too).

Download the jdbc driver for PostgreSQL here:

(use java -version to check what jvm version you've got)

onno@solin-amd64:~/schemaspy$ java -jar schemaSpy.jar -t pgsql -db nuon_clean -host localhost:5432 -u onno -o /home/onno/temp/schema -i "(.*quiz.*)|(.*question.*)" -dp postgresql-9.1-902.jdbc4.jar -p PASSWORD -s public -hq

(-hq is high quality graphics)

Personal Tools