PostgreSQL Post-Installation Tasks

On a day-to-day basis, several tasks are performed by the DBA to support the PostgreSQL database environment. With the command-line interactive psql program you can work on all administrative tasks of PostgreSQL. You can deploy all scripts interactively or with a crontab scheduler. The DBA is responsible for deploying all scripts in the production environment. Day-to-day tasks include the creation of user databases, users, schemas, grants, and roles on database objects along with table copy procedures and providing database object size estimates.