| From: | "Alexander Staubo" <alex(at)purefiction(dot)net> |
|---|---|
| To: | "Josh Harrison" <joshques(at)gmail(dot)com> |
| Cc: | "Postgresql General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Replication using WAL files |
| Date: | 2007-12-07 15:08:13 |
| Message-ID: | 88daf38c0712070708h5f146833mdd92a64ec0182d5@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/7/07, Josh Harrison <joshques(at)gmail(dot)com> wrote:
> 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.
...
> Is it possible to implement this thro' WAL shipping?
No. At the moment [1] the WAL shipping system does not permit you to
query the slave. There are a few options:
http://pgfoundry.org/search/?type_of_search=soft&words=replication&Search=Search
As well as this:
[1] But someone is working on this for 8.4. Don't hold your breath, though.
Alexander.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-12-07 15:12:27 | Re: cannot dump structures |
| Previous Message | Merlin Moncure | 2007-12-07 15:01:07 | Re: Replication using WAL files |