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@kcilink.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.
>
>
>
>
