Real time backup options. - Mailing list pgsql-novice

From Michael Lush
Subject Real time backup options.
Date
Msg-id Pine.LNX.4.64.0802081128130.8708@pigeon.ebi.ac.uk
Whole thread Raw
Responses Re: Real time backup options.  ("Shoaib Mir" <shoaibmir@gmail.com>)
List pgsql-novice
I run a modest postgres database manualy edited (via a web fron end) by
3-4 people. So the number of transactions is comparativly low.

I'd like to set up some sort of real time backups

The problem is I only have one server to run postgers on so I suspect its
a bad idea to run two instances of postgres one running on a local hard
disk the other on a NAS disk and replecate between the two.

In terms of disaster recovery I don't need anything fancy.  Just the
ability to restore from a weekly pg_dumpall then replay the subsiquent
transactions from a NAS disk.

What options should I look at?  Am I reduced to turning the logging up to
11 and stripping out the non-SQL statements?

--
Michael
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Michael John Lush PhD            Tel:44-1223 492626
Bioinformatician
HUGO Gene Nomenclature Committee    Email: hgnc@genenames.org
European Bioinformatics Institute
Hinxton, Cambridge
URL: http://www.genenames.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem integrating C stub
Next
From: "Shoaib Mir"
Date:
Subject: Re: Real time backup options.