index.html,v 1.9 2021/11/11 18:47:24 gdutton Exp

PostgreSQL Service

These documents cover the administration of the Unit PostgreSQL service, comprising the Teaching and Research servers pgteach and pgresearch.

This page is intended to assist computing staff in server administration, and is unlikely to be of use to users of our our database service. Please see our PostgreSQL Computing.Help page for user-facing documentation.

Service Information

Each postgresql server consists of two components: the database server itself, and the account management configuration provided by pgluser. The service is defined by the dice/options/postgresql-[teaching|research]-server headers, which inherit from dice/options/postgresql-RAT-server most of the basic postgresql and pgluser configuration. User management procedures are covered separately, below.

• User guide
• Account Management
• Operational guide
• Backup and restore procedure
• Major version upgrades
• Replication

 : Units : Research_and_teaching : Documentation 

Please contact us with any comments or corrections. Unless explicitly stated otherwise, all material is copyright The University of Edinburgh