From: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: Devrim GÜNDÜZ <devrim@gunduz.org>
Cc: raghu ram <raghuchennuru@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Streaming Replication limitations
Date: Wed, 13 Apr 2011 14:42:57 -0400
Message-ID: <10017.1302720177@sss.pgh.pa.us> (raw)
In-Reply-To: <BANLkTikL+0V+ZFToy3o66o02=rxEq47=mA@mail.gmail.com>
References: <BANLkTimp9PFZ-j7HRShYUWn55JgJ7h+hXA@mail.gmail.com>
<1302717319.8788.4.camel@lenovo01-laptop03.gunduz.org>
<9304.1302718017@sss.pgh.pa.us>
<BANLkTikL+0V+ZFToy3o66o02=rxEq47=mA@mail.gmail.com>
Simon Riggs <simon@2ndQuadrant.com> writes:
> 2011/4/13 Tom Lane <tgl@sss.pgh.pa.us>:
>> Short answer is to test the case you have in mind and see.
> That's the long answer, not least because the absence of a failure in
> a test is not conclusive proof that it won't fail at some point in the
> future while in production.
Not really. Every known source of incompatibility (endianness,
alignment, float format, etc) is checked at postmaster startup via
entries in pg_control. If you get the slave postmaster to start at all,
it will probably work, though certainly more extensive testing than that
would be advisable.
> The short answer is "don't do it".
DBAs are paid to be incredibly paranoid, and from that mindset this
answer makes sense. But there's a big difference between "it won't work"
and "I'm afraid to risk my paycheck on this because there might possibly
be some problem that no one knows about yet". Let's be perfectly clear
that this is a question of the second case not the first.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, simon@2ndQuadrant.com, devrim@gunduz.org, raghuchennuru@gmail.com, pgsql-general@postgresql.org
Subject: Re: Streaming Replication limitations
In-Reply-To: <10017.1302720177@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox