Hypatia PostgreSQL Database Server

The PostgreSQL server which provides the database is not particularly more complex than any other.

Starting / Stopping the database

The database can be started and stopped using the lcfg-postgresql component.

Shutdown
$ om postgresql stop
[OK] postgresql: stop
Startup
$ om postgresql start
[OK] postgresql: start

You can check that PostgreSQL has started successfully by examining its startup log:

postgres$ tail -n 20 -f /var/log/postgresql/postgresql-wk05-Mon.log
[...]
LOG:  received fast shutdown request
LOG:  aborting any active transactions
LOG:  autovacuum launcher shutting down
LOG:  shutting down
LOG:  database system is shut down
LOG:  database system was shut down at 2010-01-01 10:01:01 GMT
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections

Forcing a Restart

As specified in the lcfg-postgresql manual page, the postgresql daemon can be forced to shut down more quickly:

$ om postgresql stop -- --force

This insists that the database terminate, and marks the component as stopped.

Interpreting Logs

Logs are stored in the directory format /var/log/postgresql/postgresql-wk<week#>-.log.

Most logs produced in the postgresql logs are self-explanatory. However, a few are worth noting here:


TODO

Additionally, query audit trails are logged to /disk/backup/pglogs/*.csv.

Server Load


TODO

-- TimColles - 27 Nov 2018

Topic revision: r1 - 27 Nov 2018 - 13:36:25 - TimColles
 
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback
This Wiki uses Cookies