Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #536
| X-Received | by 10.66.193.104 with SMTP id hn8mr689726pac.46.1390316499039; Tue, 21 Jan 2014 07:01:39 -0800 (PST) |
|---|---|
| X-Received | by 10.140.48.8 with SMTP id n8mr11216qga.36.1390316498986; Tue, 21 Jan 2014 07:01:38 -0800 (PST) |
| Path | csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!a5no13931487pbg.1!news-out.google.com!gg4ni8736qab.0!nntp.google.com!6no22463254qao.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail |
| Newsgroups | comp.databases.postgresql |
| Date | Tue, 21 Jan 2014 07:01:38 -0800 (PST) |
| In-Reply-To | <m2k3dvhflg.fsf@2ndQuadrant.fr> |
| Complaints-To | groups-abuse@google.com |
| Injection-Info | glegroupsg2000goo.googlegroups.com; posting-host=62.172.108.194; posting-account=NOwgyAoAAAACEItN7zLgV-0k7Ad53JYz |
| NNTP-Posting-Host | 62.172.108.194 |
| References | <cbdd63f8-a168-48d7-a30d-0dd06097afaf@googlegroups.com> <m2k3dvhflg.fsf@2ndQuadrant.fr> |
| User-Agent | G2/1.0 |
| MIME-Version | 1.0 |
| Message-ID | <28bcf6e3-95bd-471c-bd81-eac2214aefef@googlegroups.com> (permalink) |
| Subject | Re: PostgreSQL replication using DRBD multi primary + GFS2?? |
| From | cancedda@gmail.com |
| Injection-Date | Tue, 21 Jan 2014 15:01:38 +0000 |
| Content-Type | text/plain; charset=ISO-8859-1 |
| Xref | csiph.com comp.databases.postgresql:536 |
Show key headers only | 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
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