RE: Allow logical replication to copy tables in binary format - Mailing list pgsql-hackers

From shiy.fnst@fujitsu.com
Subject RE: Allow logical replication to copy tables in binary format
Date
Msg-id OSZPR01MB631084FA9FB584A267052925FDBD9@OSZPR01MB6310.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Allow logical replication to copy tables in binary format  (Melih Mutlu <m.melihmutlu@gmail.com>)
List pgsql-hackers
On Thu, Mar 16, 2023 9:20 PM Melih Mutlu <m.melihmutlu@gmail.com>  wrote:
> 
> Hi,
> 
> Please see the attached v16.
> 

Thanks for updating the patch.

+# Cannot sync due to type mismatch
+$node_subscriber->wait_for_log(qr/ERROR: ( [A-Z0-9]+:)? incorrect binary data format/);

+# Ensure the COPY command is executed in text format on the publisher
+$node_publisher->wait_for_log(qr/LOG: ( [A-Z0-9]+:)? statement: COPY (.+)? TO STDOUT\n/);

It looks that you forgot to pass `offset` into wait_for_log().

Regards,
Shi Yu

pgsql-hackers by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: pg_dump versus hash partitioning
Next
From: Tomas Vondra
Date:
Subject: Re: zstd compression for pg_dump