All right, so I misspelled Bucardo (also Mammoth...), and the company's name
is Command Prompt (please get someone to work on that incomprehensible logo
- I went back and looked at it and still have no clue what it means :-).
Now how about some serious answers relating to my questions?
Dimitri,
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Currently we use dump (to SQL file, i.e. pg_dump with no args) + file copy
to replicate the DB daily between the staging and web servers, and then
restore
Hi,
Our configuration is as follows:
1. A staging server, which receives new data and updates the DB
2. Two web servers that have copies of the DB (essentially read-only) and
answer user queries (with load balancer)
Currently we use dump (to SQL file, i.e. pg_dump with no args) + file copy
to
Hi,
Shaul Dar shaul...@gmail.com writes:
1. A staging server, which receives new data and updates the DB
2. Two web servers that have copies of the DB (essentially read-only)
and answer user queries (with load balancer)
[...]
Suggestions?
I'd consider WAL Shipping for the staging server
Then there are Slony-I, Buchardo, Mamoth Replicator from CMO, simple
replication in Postgres 8.4 and other projects...
CMO? :)
Joshua D. Drake
Suggestions?
Thanks,
-- Shaul
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Then there are Slony-I, Buchardo, Mamoth Replicator from CMO, simple
replication in Postgres 8.4 and other projects...
CMO? :)
Buchardo? :)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200906111229
On Thu, 2009-06-11 at 16:30 +, Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Then there are Slony-I, Buchardo, Mamoth Replicator from CMO, simple
replication in Postgres 8.4 and other projects...
CMO? :)
Buchardo? :)
A new desert, Buchardo CMO: