Real time backup options.
От | Michael Lush |
---|---|
Тема | Real time backup options. |
Дата | |
Msg-id | Pine.LNX.4.64.0802081128130.8708@pigeon.ebi.ac.uk обсуждение исходный текст |
Ответы |
Re: Real time backup options.
|
Список | 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 по дате отправления: