pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Steve Baldwin <steve.baldwin@gmail.com>
Cc: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Help diagnosing replication (copy) error
Date: Fri, 8 Mar 2024 14:13:50 -0800
Message-ID: <ea5e509a-a7e9-4424-8b0d-564cbea91bb1@aklaver.com> (raw)
In-Reply-To: <CAKE1AibE1h=RVfV1GVCAQodGPB9bRuC096PLKf0S4ad1TrGkuA@mail.gmail.com>
References: <CAKE1Aib-6yvpd1mvn02haEr=EHYO2Hoq1BLQcw3JE5Ob95jZYw@mail.gmail.com>
	<f3ceeee3-ce10-49aa-8667-6d957aa9cbc4@aklaver.com>
	<CAKE1AibE1h=RVfV1GVCAQodGPB9bRuC096PLKf0S4ad1TrGkuA@mail.gmail.com>

On 3/8/24 14:04, Steve Baldwin wrote:
> 
> 
> On Sat, Mar 9, 2024 at 8:56 AM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
> 
>     What are the rest of the values in pg_replication_slots?
> 
> b2bcreditonline=> select * from pg_replication_slots;
>                    slot_name                  |  plugin  | slot_type | 
> datoid |    database     | temporary | active | active_pid | xmin | 
> catalog_xmin |  restart_lsn  | confirmed_flush_lsn | wal_status | 
> safe_wal_size | two_phase
> ---------------------------------------------+----------+-----------+--------+-----------------+-----------+--------+------------+------+--------------+---------------+---------------------+------------+---------------+-----------
>   b2bcreditonline_prod_e_master               | pgoutput | logical   | 
>   16404 | b2bcreditonline | f         | t      |      13700 |      |   
>   456150233 | 2E2F/AC07B760 | 2E2F/AEEEA478       | reserved   |         
>        | f
>   b2bcreditonline_prod_sandbox_d_master       | pgoutput | logical   | 
>   16404 | b2bcreditonline | f         | t      |       9232 |      |   
>   456150233 | 2E2F/AC07B760 | 2E2F/AEEEA560       | reserved   |         
>        | f
>   b2bcreditonline_prod_e_master_only          | pgoutput | logical   | 
>   16404 | b2bcreditonline | f         | t      |      13710 |      |   
>   456150233 | 2E2F/AC07B760 | 2E2F/AEEEA560       | reserved   |         
>        | f
>   pg_378075177_sync_60067_7343845372910323059 | pgoutput | logical   | 
>   16404 | b2bcreditonline | f         | f      |            |      |   
>   455719618 | 2E2A/1C0972E0 | 2E2A/1C097318       | extended   |         
>        | f
>   b2bcreditonline_prod_e_shard                | pgoutput | logical   | 
>   16404 | b2bcreditonline | f         | t      |      13718 |      |   
>   456150233 | 2E2F/AC07B760 | 2E2F/AEEEA560       | reserved   |         
>        | f
> (5 rows)
> 
>     Is there data in the subscriber side table?
> 
> No there is not, although when I did a 'select count(*) from {table}' it 
> took several minutes to return 0 rows.
> 
>     What are the publisher and subscriber configurations?
> 
> Not sure which settings, but here's a few.


I should been clearer.

What are the CREATE PUBLICATION and CREATE SUBSCRIPTION statements?

-- 
Adrian Klaver
adrian.klaver@aklaver.com






view thread (10+ messages)  latest in thread

Message-ID: <ea5e509a-a7e9-4424-8b0d-564cbea91bb1@aklaver.com>
Permalink:  ../ea5e509a-a7e9-4424-8b0d-564cbea91bb1@aklaver.com/
Also on:    postgresql.org/message-id/ea5e509a-a7e9-4424-8b0d-564cbea91bb1@aklaver.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: adrian.klaver@aklaver.com, steve.baldwin@gmail.com
  Subject: Re: Help diagnosing replication (copy) error
  In-Reply-To: <ea5e509a-a7e9-4424-8b0d-564cbea91bb1@aklaver.com>
  References: <CAKE1Aib-6yvpd1mvn02haEr=EHYO2Hoq1BLQcw3JE5Ob95jZYw@mail.gmail.com> <f3ceeee3-ce10-49aa-8667-6d957aa9cbc4@aklaver.com> <CAKE1AibE1h=RVfV1GVCAQodGPB9bRuC096PLKf0S4ad1TrGkuA@mail.gmail.com> <ea5e509a-a7e9-4424-8b0d-564cbea91bb1@aklaver.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox