Postgres Pro
Downloads
Home   >   mailing lists

Re: Which replication is the best for our case ? - Mailing list pgsql-general

From
Subject Re: Which replication is the best for our case ?
Date
Msg-id C5DBACC6DCC7604C9E4875FD9C7968B11A14ED7E04@ITXS01EVS.service.it.nrw.de
Whole thread Raw
In response to Re: Which replication is the best for our case ?  (Arthur Silva <arthurprs@gmail.com>)
List pgsql-general
Tree view

Arthur Silva wrote on Monday, June 29, 2015 5:23 PM:
> Therefore, I'm asking if it's possible to duplicate my main database on a
> slave server in order to run these cron on this second server... then,
> replicate these changes on the main database (master).

> http://www.postgresql.org/docs/9.3/static/warm-standby.html ?

If you do it the other way around, a hot standby (see:  http://www.postgresql.org/docs/9.3/static/hot-standby.html) might work for you.

 

That is, your cron scripts would UPDATE the master server, and the Web site would do read-only queries against the slave server.

 

That’s for the built-in replication of PostgreSQL (sorry, I have no experience with the add-on replication solutions).

 

 

pgsql-general by date:

Previous
From: Arthur Silva
Date:
Subject: Re: Which replication is the best for our case ?
Next
From: Colin Lieberman
Date:
Subject: Re: Re: Get the difference between two timestamp cells but in a special format in PostgreSQL