Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication

2025-07-17 Thread Kiran K V
6-create-logical-replication-stream > > Regards, > Kiran > > > > > Thanks > > Dinesh > > > -- > *From:* Kiran K V > *Sent:* Friday, July 11, 2025 11:09 PM > *To:* pgsql-gene...@postgresql.org > *Subject:* Query regarding support of te

Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication

2025-07-12 Thread Kiran K V
Hi, I have a question regarding the new feature introduced in PostgreSQL 16 that enables logical replication from a standby server. Currently, we are using a standalone instance of PostgreSQL 16 and performing logical replication by creating replication slots and utilizing the JDBC replication s

Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication

2025-07-12 Thread Kiran K V
Hi, I have a question regarding the new feature introduced in PostgreSQL 16 that enables logical replication from a standby server. Currently, we are using a standalone instance of PostgreSQL 16 and performing logical replication by creating replication slots and utilizing the JDBC replication st

Query related to Logical Replication using test_decoding and unchanged-toast-datum

2025-01-06 Thread Kiran K V
Hi, I am currently using PostgreSQL version 16 and the test_decoding plugin to perform logical replication (using replication slots). I have a simple table with integer column and JSON column. When a non-JSON column is updated, the value "unchanged-toast-datum" for the JSON column is obtained. Thi

Re: Issue with loading unicode characters with copy command

2024-01-14 Thread Kiran K V
Its UTF-8. Also verified the load file and its utf-8. Regards, Kiran On Fri, Jan 12, 2024 at 10:48 PM Adrian Klaver wrote: > On 1/12/24 07:23, Kiran K V wrote: > > Hi, > > > > > > I have a UTF8 database and simple table with two columns (integer and > > varch

Issue with loading unicode characters with copy command

2024-01-12 Thread Kiran K V
Hi, I have a UTF8 database and simple table with two columns (integer and varchar). Created a csv file with some multibyte characters and trying to perform load operation using the copy command. Database info: Postgresql database details: Name| Owner | Encoding | Collate

ERROR: invalid byte sequence for encoding UTF8: 0x00

2024-01-09 Thread Kiran K V
Hi, I have a table with bytea column and trying to load the data using copy command. But Copy command is failing with "ERROR: invalid byte sequence for encoding UTF8: 0x00. Why postgresql is failing to load when data contains 0x00. How to resolve this error ? any workaround to load the data with