PostgreSQL Replication – Schema Does Not Exist Error During Subscription

postgresqlreplication

PostgreSQL logical replication.

I am trying to replicate the tables from server 1 to server 2.

In Server 1

create publication locale for table code.locale_cd;
CREATE PUBLICATION

In Server 2

create subscription indsolv_dev10 connection
    'host=192.168.0.26 port=5432 password=****** user=replicator
    dbname=indsolv_dev' publication locale;

Throws an error schema "code" does not exist but it's present in the database.

Best Answer

Connect to the database where Subscription is required.

\connect indsolv_dev

Related Solutions

PostgreSQL – Configure pgpass.conf for Local Connection on Windows Server 2008

I've found it !

In Windows Service, i found that it was "adminpostgres" who was running the pgAgent service.

I just had to edit the pgpass.conf in c:/user/adminpostgres/AppData/postgresql with my old config to make it works !

PostgreSQL – Logical Replication Using pglogical

Tables and schema names in the subscriber node have to be the same as the provider node. Hereunder the error messages if the names are differents between the two nodes:

>LOG:  starting apply for subscription subscription
>INFO:  initializing subscriber subscription
>INFO:  synchronizing data
>ERROR:  schema "myschema" does not exist

>LOG:  starting apply for subscription subscription
>INFO:  initializing subscriber subscription
>INFO:  synchronizing data
>ERROR:  relation "myschema.tblprod2" does not exist

Now replication working.