Hi,
on a linux system try software raid1 for pg data. check if pg is the
right choice for your needs here. maybe flat files for config+log is
less problematic.
regards
thomas
Kokas Zsolt schrieb:
Hi!
I'd need some advice.
I'm working on a quite special field, I have to set up an embedded DB,
which will store logs (measured values) and gives configuration to the
machine and alsothis configuration can be changed.
The system will consist of a CF card (with wear leveling) and an Intel
atom CPU. The config data and the measured values together will take
up around 2-3000 rows + a couple of ten thousand rows.
The businees's side wants to make it as secure as it is possible,
meaning, that the CF card will have two partitions, and the DB should
be mirrored or distributed somehow on this two partiton, in case of a
one-point disk-error the system should stay stable.
Even though I've never used them, but as I see is, that "standard"
replication like Slony, Heartbeat+DRBD or Postgres-R are not really
able to cope with such kind of setup. Maybe I got something wrong :)
So my problem is: without a network, on one single CF card with two
partitions and only one CPU and only one server running how can it be
managed to protect the data part against media-failure.
Thanks for your help!
_______________________________
Kokas Zsolt
Save a tree...please only print this e-mail if it is genuinely required.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
