Postgres Pro
Downloads
Home   >   mailing lists

Re: RE: pg15 beta2 bug:cause by logcial replation - Mailing list pgsql-bugs

From 396934406@qq.com
Subject Re: RE: pg15 beta2 bug:cause by logcial replation
Date
Msg-id tencent_260F8B0DF71A3DBB1469C3E912B84AC90207@qq.com
Whole thread Raw
In response to pg15 beta2 bug:cause by logcial replation  ("396934406@qq.com" <396934406@qq.com>)
Responses RE: RE: pg15 beta2 bug:cause by logcial replation  ("houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>)
List pgsql-bugs
Tree view
$ /opt/pg15-beta2/bin/psql -p1502
psql (15beta2)
Type "help" for help.

postgres=# drop database logical_src;
DROP DATABASE
postgres=# drop database logical_dest ;
DROP DATABASE
postgres=# select version();
                                                  version                                                   
------------------------------------------------------------------------------------------------------------
 PostgreSQL 15beta2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit
(1 row)

postgres=# create database logical_src;
CREATE DATABASE
postgres=# create database logical_dest;
CREATE DATABASE
postgres=# \c logical_src
You are now connected to database "logical_src" as user "postgres".
logical_src=# create table tab1(id int primary key,info varchar);
CREATE TABLE
logical_src=# create table tab2(id int primary key,info1 varchar,info2 varchar);
CREATE TABLE
logical_src=# select pg_create_logical_replication_slot('logical_slot1','pgoutput');
 pg_create_logical_replication_slot 
------------------------------------
 (logical_slot1,0/4976D9D8)
(1 row)

logical_src=# create publication pub_two for table tab1, tab2;
CREATE PUBLICATION
logical_src=# \c logical_dest
You are now connected to database "logical_dest" as user "postgres".
logical_dest=# create table tab1(id int primary key,info varchar);
CREATE TABLE
logical_dest=# create table tab2(id int primary key,info1 varchar,info2 varchar);
CREATE TABLE
logical_dest=# create subscription sub_two 
logical_dest-#  connection 'hostaddr=127.0.0.1 port=1501 user=postgres dbname=logical_src' 
logical_dest-#  publication pub_two with(create_slot='false',slot_name='logical_slot1');
ERROR:  could not receive list of replicated tables from the publisher: ERROR:  column t.attnames does not exist
LINE 2: , t.attnames
          ^


396934406@qq.com
 
Date: 2022-07-01 12:09
Subject: RE: pg15 beta2 bug:cause by logcial replation
On Friday, July 1, 2022 11:35 AM 396934406@qq.com <396934406@qq.com>  wrote:
> hello,:
>
>   i am jerome Peng,  from pg15 beta2  changes since beta 1 , i test this item and found a error:
>
> ? pg_publication_tables now provides information on column lists and row filters.
>
> \c logical_src
> create table tab1(id int primary key,info varchar);
> create table tab2(id int primary key,info1 varchar,info2 varchar);
> select pg_create_logical_replication_slot('logical_slot1','pgoutput');
> create publication pub_two for table tab1, tab2;
>
> \c logical_dest
> create table tab1(id int primary key,info varchar);
> create table tab2(id int primary key,info1 varchar,info2 varchar);
> create subscription sub_two
>  connection 'hostaddr=127.0.0.1 port=1501 user=postgres dbname=logical_src'
>  publication pub_two with(create_slot='false',slot_name='logical_slot1');
>
> ERROR:  could not receive list of replicated tables from the publisher: ERROR:  column t.attnames does not exist
> LINE 2: , t.attnames
 
Hi,
 
I tried your reproduction steps but cannot get the same error.
 
Can you please provide some more information about the version
of publisher and subscriber you used ?
 
Just to confirm, did you use the PG15 beta1 or earlier PG15 version
as the publisher and use PG15 beta2 as the subscriber ?
 
Best regards,
Hou zj

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg15 beta2 bug:cause by logcial replation
Next
From: "396934406@qq.com"
Date:
Subject: Re: Re: pg15 beta2 bug:cause by logcial replation