Re: [GENERAL] Schema/table replication

2017-09-06 Thread Marcin Giedz
Does pglogical support views replication as I can't find it in any restrictions ? Thx Marcin Od: "Steve Atkins" Do: pgsql-general@postgresql.org Wysłane: środa, 6 wrzesień 2017 17:22:14 Temat: Re: [GENERAL] Schema/table replication > On Sep 6, 2017, at 6:00 AM, M

[GENERAL] Schema/table replication

2017-09-06 Thread Marcin Giedz
Hi, is there any way (3rd party software) to replicate particular schema/table not the whole database with streaming replication built-in mechanism ? Thx Marcin

Re: [GENERAL] Total ram size study

2017-04-22 Thread Marcin Giedz
Is it possible so you can share your postgresql.conf file and system settings if any for this 256G ram installation pls? Thx Marcin Sent from my BlackBerry 10 smartphone. From: Melvin Davidson Sent: Saturday, April 22, 2017 18:31 To: Vick Khera Reply To: Melvin Davidson Cc: pgsql-general@

[GENERAL] PostgreSQl HA solution

2016-11-30 Thread Marcin Giedz
Hello, Does anyone know any reliable open source HA solution with stream replication and IP live migration in case of master node failure? Recently I've been attending Fujitsu PostgreSQL webinar and they presented so called "mirroring controler" + sync stream replication . I'm wondering if thi

[GENERAL] Auotreconnect/failover libpq

2016-10-28 Thread Marcin Giedz
Hello, This time question about client's autoreconnect (failover to the same node) after disconnection. Let's assume I've got 1 node SQL server and clients connected to this machine. Is there any native autoreconnect method in libpq (client's software uses libpq C++) - something like SELECT 1

Re: [GENERAL] libpq heartbeat

2016-10-27 Thread Marcin Giedz
r for some reasons? I'll be able to check this next morning. Regards Marcin Od: "Tom Lane" Do: "Francisco Olarte" DW: "depesz" , "Marcin Giedz" , pgsql-general@postgresql.org Wysłane: czwartek, 27 październik 2016 18:32:54 Temat: Re: [GENERAL

[GENERAL] libpq heartbeat

2016-10-27 Thread Marcin Giedz
Hello all I'm wondering if there is any natural implementation of heartbeats in libpq library? We've been facing specially in firewall env occasionally session drops between client and server. Extending session timeout directly on firewalls is not possible (company rules). Perhaps there is suc