From: | Michael Lush <mjlush(at)ebi(dot)ac(dot)uk> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Real time backup options. |
Date: | 2008-02-08 12:22:47 |
Message-ID: | Pine.LNX.4.64.0802081128130.8708@pigeon.ebi.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)genenames(dot)org
European Bioinformatics Institute
Hinxton, Cambridge
URL: http://www.genenames.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From | Date | Subject | |
---|---|---|---|
Next Message | Shoaib Mir | 2008-02-08 13:30:30 | Re: Real time backup options. |
Previous Message | Tom Lane | 2008-02-07 16:17:17 | Re: Problem integrating C stub |