pglogical

pglogical copied to clipboard

pglogical performance on large number of tables

1

Hi, We are evaluating using pglogical on a Database with thousands of tables from 300+ schemas. Would that cause and performance bottle neck?

carolfly86

could not open directory "pg_replslot/b_master_master2slave": No such file or directory

8

# Environment Windows 10, pglogical 2.2.0 built with MSYS2, PostgreSQL 10.3 # Installation ## On provider: ``` create table foo( id bigserial primary key, val text ); insert into foo...

pashagolub

Hi, I am testing pglogical for uni-directional replication between 2 data centers with double digit ms network latency . With WAL generation rate of 20-25MB/sec on source database , I...

sunilbhu

pglogical.synchronize_sequence syncs incorrect value to subscriber (source value + 1000)

16

I am trying to use pglogical to migrate a Postgres 9.5 cluster running on FC24 to a new server running Postgres 9.6 on CentOS 7. It seems to be working...

dba-brewer

TRUNCATE not replicated when executed with session_replication_role='replica'

5

pglogical 2.1.1, postgresql 10.5 We have setup replication on table `trunc_test` between two databases. It works well except for TRUNCATE. It does not replicate to target database when executed in...

gargii

Subscriber throws connection to the other side died error

3

Hello, We currently have a provider subscriber setup on PostgreSQL 10.12 using pglogical 2.2.1. Off lately we are seeing the following error on the subscriber end: `< 2021-04-10 09:55:05.147 EDT...

Viralshah009

On my system is see these tables: ``` pglogical.depend pglogical.node pglogical.replication_set pglogical.sequence_state pglogical.local_node pglogical.node_interface pglogical.replication_set_seq pglogical.subscription pglogical.local_sync_status pglogical.queue pglogical.replication_set_table pglogical.tables ``` I would like to understand these tables. It would...

guettli

Hello. I have been using the "default_insert_only" replication set, and have discovered that truncate gets replicated for this set. Is this intended? Here's the code snippet from pglogical_functions.c : pglogical_create_node(PG_FUNCTION_ARGS)...

kmercer0423

Segfault with triggers

3

Hi, I use PostgreSQL 11.6 and pglogical 2.2.2 on debian, with deb packages. I'm using two instances in the same system. As I need to filter DELETE on the subscriber...

slardiere

Can't compile in windows due to spaces in paths

12

pglogical_apply.o pglogical_conflict.o pglogical_manager.o pglogical.o pglogical_node.o pglogical_relcache.o pglogical_repset.o pglogical_rpc.o pglogical_functions.o pglogical_queue.o pglogical_fe.o pglogical_worker.o pglogical_sync.o pglogical_sequences.o pglogical_executor.o pglogical_dependency.o pglogical_apply_heap.o pglogical_apply_spi.o pglogical_output_config.o pglogical_output_plugin.o pglogical_output_proto.o pglogical_proto_json.o pglogical_proto_native.o /compat96/pglogical_compat.o makefile:81: C:/Program: No such file or...

vanceism7