Horton

Re: Snapshot synchronization, again...

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Joachim Wieland <joe@mcknight.de>
Cc: Alvaro Herrera <alvherre@commandprompt.com>, Noah Misch <noah@leadboat.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2011-02-22T07:10:13Z
Lists: pgsql-hackers 
On 21.02.2011 21:33, Joachim Wieland wrote:
> Hi,
>
> On Mon, Feb 21, 2011 at 4:56 PM, Alvaro Herrera
> <alvherre@commandprompt.com>  wrote:
>> What's the reason for this restriction?
>>         if (databaseId != MyDatabaseId)
>>                 ereport(ERROR,
>>                         (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
>>                          errmsg("cannot import snapshot from a different database")));
>
> I just couldn't think of a use case for it and so didn't want to
> introduce a feature that we might have to support in the future then.

Hmm, here's one: getting a consistent snapshot of all databases in 
pg_dumpall. Not sure how useful that is..

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com