Databases may be created by any of our users for either research or course work.
Our database servers rely on highly available PostgreSQL clusters running pgpool2. Users can connect to a database proxy server, to interact with the back-end database cluster. All databases are periodically backed-up.
Future Database Accounts and Authentication
We are currently developing a new PostgreSQL cluster. Users will use a web-based form on the CS department website to manage their databases. Keep a lookout here for more information during Spring 2022.
PostgreSQL Tutorials / Help
Help in the Command Line
Postgresql has built-in help information. For "meta" commands (such as \c), issue the command
For help with SQL syntax, use