Re: [GENERAL] Fully-automatic streaming replication failover when master dies?

2014-01-26 Thread Michael Paquier
On Mon, Jan 27, 2014 at 12:35 PM, Sameer Kumar wrote: > > On Mon, Jan 27, 2014 at 11:24 AM, Michael Paquier < > michael.paqu...@gmail.com> wrote: > >> PostgreSQL supports synchronous multi-master, MongoDB supports write concern, but this causes a performance penalty). >>> >>> Anyways I doubt

Re: [GENERAL] Fully-automatic streaming replication failover when master dies?

2014-01-26 Thread Tatsuo Ishii
> I know about PostgresXC, but I thought it is distributed database (similar > to shards of mongoDB). [Though if I am correct there could be tables which > are shared across different nodes, but that is not the best way of > utilizing features of PostgresXC] I think it is not apt to call it > "sync

Re: [GENERAL] Fully-automatic streaming replication failover when master dies?

2014-01-26 Thread Sameer Kumar
On Mon, Jan 27, 2014 at 11:24 AM, Michael Paquier wrote: > PostgreSQL supports synchronous multi-master, MongoDB supports write >>> concern, but this causes a performance penalty). >> >> Anyways I doubt that "PostgreSQL supports synchronous multi-master" >> > Postgres core taken as such does not

Re: [GENERAL] Fully-automatic streaming replication failover when master dies?

2014-01-26 Thread Michael Paquier
On Mon, Jan 27, 2014 at 12:10 PM, Sameer Kumar wrote: > > Dmitry Koterov wrote: > >> PostgreSQL supports synchronous multi-master, MongoDB supports write >> concern, but this causes a performance penalty). > > Anyways I doubt that "PostgreSQL supports synchronous multi-master" > Postgres core taken

Re: [GENERAL] Fully-automatic streaming replication failover when master dies?

2014-01-26 Thread Sameer Kumar
On Sun, Jan 26, 2014 at 12:50 PM, Scott Marlowe wrote: > Are you running your cluster in synchronous mode across geographically > diverse data centers? If not how long do you wait for the master to > come back before you fail over? A millisecond? A second? A minute? The > answer will likely be dif

[GENERAL] fastest dump/restore

2014-01-26 Thread Scott Ribe
Is there an article anywhere which documents everything the current state of the art for the fastest dump/restore? What dump/restore format & options? What things to tweak in the config? I've picked up a few bits here and there along the line, but was just wondering if there's a comprehensive so

Re: [GENERAL] pg_dump: dumpBlobs(): could not open large object: ERROR: large object 27729547 does not exist

2014-01-26 Thread Alban Hertroys
On 26 Jan 2014, at 2:34, Michael Paquier wrote: > On Fri, Jan 24, 2014 at 10:33 PM, Manoj Agarwal wrote: >> Hi, >> >> I have a Postgresql-7.4.19 database in SQL_ASCII Encoding format. > You should really consider an upgrade first... As mentioned by Kevin > this version is outdated. The latest