Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The recovery point objective for the database is 24 hours. Hema, is this acceptable? I am assuming that, given our limited resources, we will use database backups for recovery, and that we do not want to use replication. If we were to use replication, we could have a recovery point objective right down to a single transaction. But we have no expertise here and so I recommend against this approach.

Administration Roles

  • user administration
  • linux system admin
  • postgres db admin
  • production support

...

user administration

...

todoWe need some wiki pages and some bodies - detailed below

...

user administration

...

Hema, can DBI help with this?

linux system admin

sfgis will do this
todo - wiki pages

postgres db admin

sfgis will do this
We should have a real DBA sign on.
todo - wiki pages

production support

sfgis will do this
todo - wiki pages