Re: ERROR: too many dynamic shared memory segments

2017-12-07 Thread Jakub Glapa
Thank You Thomas! -- regards, Jakub Glapa On Thu, Dec 7, 2017 at 10:30 PM, Thomas Munro wrote: > On Tue, Dec 5, 2017 at 1:18 AM, Jakub Glapa wrote: > > I see that the segfault is under active discussion but just wanted to > ask if > > increasing the max_connections to mitigate the DSM slots

Re: ERROR: too many dynamic shared memory segments

2017-12-07 Thread Thomas Munro
On Tue, Dec 5, 2017 at 1:18 AM, Jakub Glapa wrote: > I see that the segfault is under active discussion but just wanted to ask if > increasing the max_connections to mitigate the DSM slots shortage is the way > to go? Hi Jakub, Yes. In future releases this situation will improve (maybe we'll fi

Re: replication terminated by primary server

2017-12-07 Thread Payal Singh
On Wed, Dec 6, 2017 at 8:07 AM, Bruyninckx Kristof < kristof.bruynin...@cegeka.com> wrote: > > > In our environment, we have a master slave replication setup that has been > working stable for the last year. > > Host systems are debian Jessie and we are using postgres 9.4. > > Now recently we have

Re: Infinite replication loop with pglogical

2017-12-07 Thread Peter J. Holzer
On 2017-12-07 14:41:31 +0100, Peter J. Holzer wrote: > We are testing bidirectional replication with pglogical: [...] > We have configured bidirectional replication on several tables. In > general that seems to work fine. When a row is inserted/updated/ > deleted on one node, it is replicated to th

Infinite replication loop with pglogical

2017-12-07 Thread Peter J. Holzer
[I'm not sure whether this is the right list to discuss third party extensions like 2ndQuadrant's pglogical. If there is a better place, feel free to direct me to it] We are testing bidirectional replication with pglogical: Node 1: postgresql-9.6 9.6.6-1.pgdg90+1 postgresql-9.6

Missing RHEL rpm(pg_catcheck-10) in postgres 10 repo.

2017-12-07 Thread Kaliappa, Karthic
Hello team, We are looking to upgrade our application from postgres 9.5 to 10x, but we are unable to find the RPM named 'pg_catcheck-10x' for Redhat: https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6.7-x86_64/ We request your help in getting this rpm to the repo. Thanks, Karthic.