Last Comment Bug 829785 - Event - (2013-02-06 12:00 UTC-8) - Ten Forward - Postgres and Backups
: Event - (2013-02-06 12:00 UTC-8) - Ten Forward - Postgres and Backups
event has been rescheduled
Product: Air Mozilla
Classification: Other
Component: Events (show other bugs)
: unspecified
: All Other
-- normal
: ---
Assigned To: Patrick Dang [:pdang]
Depends on:
  Show dependency treegraph
Reported: 2013-01-11 14:34 PST by Selena Deckelmann :selenamarie :selena use ni?
Modified: 2013-03-05 08:07 PST (History)
4 users (show)
See Also:
QA Whiteboard:
Iteration: ---
Points: ---


Description User image Selena Deckelmann :selenamarie :selena use ni? 2013-01-11 14:34:12 PST
Topic: Postgres and Backups
Presenter: Selena Deckelmann
Date: 2013-02-06
Time: 12:00 UTC-8
Duration: 1 Hour
Privacy: The Public
Large Screen Location: MTV, 
A wise DBA once said: you don't have working backups, only working restores. 

This brownbag will demystify the two types of backup and restore for PostgreSQL (Postgres) and help you understand how to recover from a database failure.

Postgres is a powerful, open source SQL database used by Socorro (, and one of many database systems used by Mozilla. This talk will provide an overview of Postgres architecture, the core replication system that enables binary backups, and explain the reasons why you never need to take a Postgres database offline for backups.  We'll also cover strategies for managing high-write load systems and high availability.

Special Requirements:
I'll have slides to present from a laptop and would like to broadcast on #airmozilla.
Comment 1 User image Selena Deckelmann :selenamarie :selena use ni? 2013-02-05 12:48:26 PST
Postponing due to conflict with mary's event.
Comment 2 User image Richard A Milewski[:richard] 2013-02-06 09:04:13 PST
Reopening to make it available for rescheduling.
Comment 3 User image Richard A Milewski[:richard] 2013-03-05 08:07:41 PST
Closing this bug for now.   Reopen it when you're ready to reschedule.

Note You need to log in before you can comment on or make changes to this bug.