Skip to main content
Stack Overflow
  1. About
  3. For Teams
Filter by
Sorted by
Tagged with
2 votes
0 answers
40 views

I am attempting to logically replicate a production postgres instance to facilitate a blue/green major version upgrade from 13 -> 18 (don't ask). First, I start a replication slot on the blue (...
1 vote
1 answer
69 views

I have a program which receives postgres(16) logical replication stream. I am following documentation to understand message types for logical replication. Messages types I see are S, K, Z, W, d. But ...
0 votes
2 answers
208 views

I'm trying to create a logical replication slot on a GCP managed PostgreSQL 17 read replica but getting intermittent failures with two different errors. The replica was recently upgraded from ...
0 votes
2 answers
89 views

My understanding is that PostgreSQL retains WAL from restart_lsn because the logical decoder might need data before confirmed_flush_lsn to produce output for transactions that have not yet been ...
1 vote
1 answer
101 views

I am trying to consume logical replication data from postgres. I follow this. First I establish pg connection as: pub async fn logical_replication_connection() -> Result<tokio_postgres::Client, ...
0 votes
0 answers
29 views

I want to replicate Oracle to PostgreSQL in real time with schema evolution support. Is there is any open source tool available? I am not using Oracle Goldengate. It is too heavy and time consuming to ...
0 votes
1 answer
74 views

I'm using PostgreSQL logical replication, and both the origin and destination databases have the same table structure — table A (a int primary key, b int). I'm trying to create a trigger that ...
0 votes
1 answer
72 views

Code do $$BEGIN perform pg_create_logical_replication_slot('test', 'pgoutput', false); END$$ ; create publication Jalgi_pub for all tables; select * from pg_logical_slot_peek_binary_changes('test', ...
0 votes
0 answers
74 views

Replication events are displayed by ASP.NET Core 9 MVC controller according using code: public async Task Index() { const string slotName = "all_slot"; await ctx.Database....
0 votes
0 answers
63 views

Postgres 14 hot standby server server is running in Debian Linux under WSL. It saves wal log from master to pg_wal directory. wal_keep size is 100 GB. Command pg_recvlogical -P pgoutput -o ...
0 votes
0 answers
88 views

Im trying to copy initial table data around 100 to 200 GB to a file in text format.I created a connection-1 and started a transaction with isolation level REPEATABLE READ and exported a snapshot to ...
0 votes
0 answers
165 views

In the replication client, I sometimes need to exit copy mode to perform SQL queries, and then return to slot replication, but when I re-issue the slot start command, I get a response from the server ...
1 vote
0 answers
103 views

I have an issue with catching all the data with AFTER INSERT trigger on my PostgreSQL 16 logical replication. I simplified my tables into create table customer (id serial, email text); create table ...
0 votes
0 answers
795 views

we upgraded our DB systems from Postgres 15 to Postgres 17. Everything is working, but i see those strange errors in the log file of our subscriber (logical replication): [user=postgres,db=template1,...
Tom's user avatar
  • 520
0 votes
1 answer
752 views

We are using Debezium connectors to stream PostgreSQL data into kafka. We will have a major version upgrade on PostgreSQL(13 to 16) by side by side approach using logical replication to new server. ...

15 30 50 per page
1
2 3 4 5
...
10

AltStyle によって変換されたページ (->オリジナル) /