From: | "Josh Harrison" <joshques(at)gmail(dot)com> |
---|---|
To: | "Postgresql General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Replication using WAL files |
Date: | 2007-12-07 14:52:47 |
Message-ID: | 8d89ea1d0712070652q7d60f6f3nf370b59743538a1d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi list,
I'm a newbie for postgresql replication
This is my requirement.
I have 2 servers on which I need to have data replicated. The master server
should serve for read/write queries and the 2nd server is used mainly for
research queries(read-only queries) and so it doesn't have to be up-to-date.
The read queries should be able to be sent to both servers so load-balancing
is possible. In case the master server fails the 2nd server should be able
to take over(fair-over support).
Is it possible to implement this thro' WAL shipping?
I tried the 'Continuous Archiving and PITR' in my test database and it works
fine. But this set-up is only for a warm standby server...right?! Is it
possible to make both the servers work asynchronously, while the primary
server takes up all write queries and the read queries can be sent to both
primary and 2nd server .And can the 2nd server be updated using the WAL
files (WAL shipping) of the primary server asynchronously (while both the
servers are up)?
Hope I explained my requirement clearly.
Please advice
Thanks
josh
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2007-12-07 15:01:07 | Re: Replication using WAL files |
Previous Message | Martin Korous | 2007-12-07 14:42:01 | cannot dump structures |