From: | Dennis Gearon <gearond(at)fireserve(dot)net> |
---|---|
To: | Greg Stark <gsstark(at)mit(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Linux ready for high-volume databases? |
Date: | 2003-08-26 18:46:44 |
Message-ID: | 3F4BAB14.8060709@fireserve.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
With the low cost of disks, it might be a good idea to just copy to
disks, that one can put back in.
Greg Stark wrote:
>Vivek Khera <khera(at)kcilink(dot)com> writes:
>
>
>
>>I run a 24x7x365 db on FreeBSD which has *never* crashed in the 3
>>years it has been in production. Only downtime was the upgrade from
>>PG 7.1 to 7.2 and once for a switchover from RAID5 to RAID10.
>>
>>
>
>I would be interested to know what backup strategy you use for this. Without
>online backups this means that if you had crashed you would have lost data up
>to the last pg_dump you took? Had you done tests to see how long it would have
>taken to restore from the pg_dump?
>
>Online backups with archived transaction logs are the next big killer feature
>(the last one remaining?) for 24x7 operation I think.
>
>
>
>>The DB is currently about 27Mb on disk (including indexes) and
>>processes several million inserts and updates daily, and a few million
>>deletes once every two weeks.
>>
>>
>
>Oh, it's a really small database. That helps a lot with the backup problems of
>24x7 operation. Still I would be interested.
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Robert L Mathews | 2003-08-26 19:48:37 | Re: move to usenet? |
Previous Message | Darko Prenosil | 2003-08-26 18:42:27 | Re: Fwd: installing postgres7.3.4 problem II |