| From: | "Steve Poe" <steve(dot)poe(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Planning hot/live backups? |
| Date: | 2008-03-24 20:23:08 |
| Message-ID: | 721b21dc0803241323u73443060w3a1912d52714549b@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
The owners of the animal hospital where I work at want to consider live/hot
backups through out the day so we're less likely to lose a whole
day of transaction. We use Postgresql 8.0.15. We do 3AM
backups, using pg_dumpall, to a file when there is very little activity.
The hospital enjoys the overall performance of the veterinary
application running
on Postgresql. I know doing a mid-day backup when up to 60 computers
(consistently
35-40) are access client/patient information, it will cause some
frustration. I understand
there needs to be balance of performance and backup of current records.
While I know that not all situations are the same, I am hoping there
is a performance
latency that others have experienced when doing backups during the day and/or
planning for cluster (or other types of redundancy).
My animal hospital operates 24x7 and is in the south part of the San
Francisco Bay area. Outside
of sharing your experiences/input with me, I would not mind if you/your company
do this type of consulting offline.
Thank you.
Steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Campbell, Lance | 2008-03-24 20:39:32 | Re: Planning hot/live backups? |
| Previous Message | Bruce Momjian | 2008-03-24 17:44:08 | Re: FW: was [PERFORM] partitioned table and ORDER BY indexed_field DESC LIMIT 1 |