We had similar database architecture like yours before. Our 4 databases are
for sharding purpose. We used Bucardo to replicate from 4 different
databases, aggregate them into 1 collector database.
For the 4 databases A,B,C,D, for their auto increment sequence, we set them
with different "start wit
We have client databases in 3 different region in the world, namely:
cr_master, mx_master & mlt_master db. These 3 databases have exactly the
same structure, with different subset of client data.
For reporting purpose, we aggregate these 3 db to single collector, using
Bucardo replication. Recentl
Thanks everyone for the reply. So I would conclude it as OpenVZ problem,
probably we will run some further check just to make sure no data
corruption.
Many thanks again :)
On Thu, Dec 5, 2013 at 12:23 AM, Kevin Grittner wrote:
> Albe Laurenz wrote:
> > Shuwn Yuan Tee wrote:
&g
We recently experienced crash on out postgres production server. Here's our
server environment:
- Postgres 9.3
- in OpenVZ container
- total memory: 64GB
Here's the error snippet from postgres log:
ERROR: could not read block 356121 in file "base/33134/33598.2": Bad
address
LOG: server proces
