just a query from the db maintanence point of view.
was viewing the following forum, did not make complete sense, but just wondering, how do we maintain the db if we are unable to access it, backup etc.
the discusion of one of the forum is as below
http://forums.matrix.squiz.net/index.php?showtopic=1492
[quote]was viewing the following forum, did not make complete sense, but just wondering, how do we maintain the db if we are unable to access it, backup etc.
[right][post=“8629”]<{POST_SNAPBACK}>[/post][/right][/quote]
Matrix ships with a backup script that is used to create a copy of the database for backup purposes. Otherwise, there is no ongoing maintenance required for the database itself. Matrix takes care of that either automatically, or via a provided command-line script.
does the script also have the following.
- Restoration of backup db.
- script for import / export tables.
[quote]1. Restoration of backup db.
2. script for import / export tables.
[right][post=“8636”]<{POST_SNAPBACK}>[/post][/right][/quote]
Under an SLA, restoration from the backup is done by Squiz using standard PostgreSQL tools (pg_restore and psql). There is no ability to import or export tables for any purpose in Matrix.