Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #536

Re: PostgreSQL replication using DRBD multi primary + GFS2??

Show all headers | View raw

On Sunday, 19 January 2014 20:38:35 UTC, Dimitri Fontaine  wrote:
> **@gmail.com writes:
> 
> > What I need is the fastest replication possible and the second PostgreSQL
> 
> > server should be a read only just to run reports and selects.
> 
> 
> 
>   http://www.postgresql.org/docs/current/interactive/hot-standby.html
> 
> 
> 
> -- 
> 
> Dimitri Fontaine
> 
> PostgreSQL DBA, Architecte

Hi Dimitri,

Thanks for the answer.

We tried that already but long queries being run on the master break replication and make running queries on the slave impossible to complete.

Or that's what I got reading about the error.

Please let me know if I'm wrong.

Kind regards,
Marco

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

PostgreSQL replication using DRBD multi primary + GFS2?? cancedda@gmail.com - 2014-01-19 10:15 -0800
  Re: PostgreSQL replication using DRBD multi primary + GFS2?? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2014-01-19 21:38 +0100
    Re: PostgreSQL replication using DRBD multi primary + GFS2?? cancedda@gmail.com - 2014-01-21 07:01 -0800
      Re: PostgreSQL replication using DRBD multi primary + GFS2?? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2014-01-21 16:24 +0100

csiph-web