Replication using WAL files

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

Responses

Browse pgsql-general by date

  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