Disaster Recovery for PostgreSQL 9.0
First, repeat after me:


  A replica is not a backup


That is your first problem.  Do not use replication as a substitute for backups.  Replication is a useful part of a disaster recovery strategy.  It is not a useful disaster recovery strategy.

For PostgreSQL 9.0.x I would recommend that you take a look at barman, an open source backup and archive manager for PostgreSQL by 2ndQuadrant.  This helps manage some of the details so you don't have to.  (Full disclosure: I am a principal consultant for 2ndQuadrant.)

This being said, barman is only helpful if you are relatively familiar already with the base backup/wal shipping approach (which is what you want so you can roll back human errors like this).  This is necessary for PITR to work.

In this approach you set up two things.  The first is a base backup (see the pg_basebackup documentation for how).  Note you cannot use a logical backup (i.e. from pg_dump for this).  The second is to set up continuous archiving so that you can take your WAL segments and use them for PITR.   The specifics here depend highly on your environment and so you want to take a look at the docs and design something that works for you.  True to the UNIX way, these are largely tools for building your backup and recovery solution.  There isn't much more that can be said about this without something more specific, but start there and build a solution for your business out from it.