Questions tagged [pg-logical]
The pg-logical tag has no usage guidance.
17
questions
0
votes
0
answers
8
views
Read Postgres CDC data with Logical Replication via Pgoutput plugin and decode it into textual format
Background: We are running Postgres v13.4 and have enabled logical replication for reading CDC data for a select few tables. We are using the pgoutput plugin and the basic setup is working fine.
Query:...
- 1
0
votes
1
answer
37
views
Upgrading Logical Replica of PostgreSQL
I am trying to upgrade a logical replica from PostgreSQL V10 to V13. We are using pglogical for the logical replication.
Though the upgrade process of the replica can be done, however the replication ...
- 442
1
vote
1
answer
81
views
Installing pglogical: Find postgres include folder, add all include folders to C_INCLUDE_PATH
I am trying to install the pglogical extension in my postgres database, which I installed on my macOS with homebrew. I am following instructions provided on the GCP blog as I am preparing to migrate ...
0
votes
0
answers
105
views
pglogical: list Schema/table part of the replication sets?
Is there a way to list all the Schemas which have been added to the replication_set?
# SELECT * FROM pglogical.replication_set;
set_id | set_nodeid | set_name | replicate_insert | ...
2
votes
1
answer
187
views
Why can't I setup replication with pglogical? It says I need a primary key even though I have unique constraints
I'm trying to enable replication with pglogical on a database running Postgres 9.6.22, however I can't add one of my tables even though it has a unique constraint:
db=> SELECT pglogical....
- 31
2
votes
1
answer
313
views
Postgres major version upgrade using replication server
I am planning to upgrade my database from Postgres 10 to Posgres 14. To reduce the downtime, I plan to use the replication for the same. Plan (in short) is to:
Dump the data using pg_dumpall
Kill the ...
- 121
0
votes
0
answers
335
views
Postgresql pg_logical sequence replication not synchronized
I'm testing pg_logical extension for Postgresql because we need to replicate some clusters with Postgresql 9.6 before upgrading them to newer version, where logical replication is a core feature.
I've ...
- 125
3
votes
1
answer
466
views
Postgres difference between restart_lsn and confirmed_flush
According to the documentation, restart_lsn is
The address (LSN) of oldest WAL which still might be required by the consumer of this slot and thus won't be automatically removed during checkpoints...
...
- 135
0
votes
1
answer
188
views
Show more details on Postgres logical replication errors
Wonder if there is a way to add more details (like the column name, database) to logical replication errors in case of missing columns. I got general log entries like this:
2021-09-16 14:47:37.149 CDT ...
0
votes
1
answer
124
views
Limit size of WAL files for PostgreSQL database
I'm using AWS RDS PostgreSQL 13 database in a master-slave configuration using logical replication with pglogical extension.
Recently, one of the application migrations has updated the schema of the ...
- 101
1
vote
0
answers
50
views
Create logical replication along with normal replication [closed]
I need to replicate only some of the tables from my Master Postgres.
With Google search, I got to know that it is possible with logical replication from Postgres10.
I already have a read-only replica ...
0
votes
0
answers
226
views
Unable to replicate Postgres tables using logical replication in RDS
Tables in the destination database are empty even after subscription is successful.
I am extremely new to logical replication within Postgres. I am trying to replicate three tables from the source ...
0
votes
2
answers
79
views
Error when passing variable to function
I've created a function in PostgreSQL 11.10 to handle DDL change in pglogical to apply it into subscriber. Here is the function:
CREATE OR REPLACE FUNCTION public.intercept_ddl()
RETURNS ...
0
votes
0
answers
88
views
2ndQuadrant/Pglogical multi-master cluster installation
I'm looking for a way to make a multi-master cluster with pglogical.
When I say multi-master, it's means 3 nodes, where each of them is a provider and a subscriber.
Currently I have two nodes that ...
- 1
2
votes
1
answer
144
views
Pglogical - multiple database tables to single table
I have 4 databases, each database is having 2 tables. The table structure on all the databases are same. So i want to replicate these two tables from all 4 databases to a single database.
So my ...
- 1,698
0
votes
1
answer
134
views
Dump pglogical Config to files
We use the tool etckeeper to keep track of the configuration of servers.
I would like to dump the configuration of pglogical to files for this purpose.
I tried this:
db@host:~$ pg_dump -t '...
- 1,331
0
votes
1
answer
231
views
How to resolve the error for "Alter Subscription disable"?
I have the following subscription for logical replication:
pctest1=> SELECT subscription_name, status FROM pglogical.show_subscription_status();
subscription_name | status
----...
- 83