Re: bdr replication

From: Slava Bendersky <volga629(at)skillsearch(dot)ca>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: bdr replication
Date: 2016-03-31 05:17:55
Message-ID: 691049027.2108447.1459401475211.JavaMail.zimbra@skillsearch.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Everyone,
Is possible recovery from my situation at all ? I was looking on tool which might will help and only bdr_init_copy. If possible initialize second node again ? Also is it good idea enable wal archiving with bdr ?

volga629

From: "volga629" <volga629(at)skillsearch(dot)ca>
To: "John R Pierce" <pierce(at)hogranch(dot)com>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, 31 March, 2016 00:57:13
Subject: Re: [GENERAL] bdr replication

In my case only virtual hosts are use share storage (feed from glusterfs), but actual virtual machines have own separate disks and all PostgreSQL run on separate data directories.

volga629

From: "John R Pierce" <pierce(at)hogranch(dot)com>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, 31 March, 2016 00:34:55
Subject: Re: [GENERAL] bdr replication

On 3/30/2016 8:09 PM, Slava Bendersky wrote:
> Is any share storage technology recommended for PostgreSQL in virtual
> environment ?
> Ok what I will do is going take backups, shutdown both virtual servers
> and place all vm use local disk on server only.

'share storage technology'... um. thats such a vague term, it can
mean lots of things.

each postgres instance needs its own data store, two instances can NOT
share the same files under any condition. these data stores can be
on SAN or NAS, as long the storage is reliable about committed random
writes, and as long as two different servers aren't using the SAME
directory for their data stores.

--
john r pierce, recycling bits in santa cruz

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Aguayo Garcia-Rada 2016-03-31 05:19:42 Re: bdr replication
Previous Message Slava Bendersky 2016-03-31 03:57:13 Re: bdr replication