Re: Patch for migration of the pg_commit_ts directory

ls7777 <ls7777@yandex.ru>

From: ls7777 <ls7777@yandex.ru>
To: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>, Masahiko Sawada <sawada.mshk@gmail.com>
Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>, "orlovmg@gmail.com" <orlovmg@gmail.com>, "amit.kapila16@gmail.com" <amit.kapila16@gmail.com>
Date: 2026-04-06T04:34:08Z
Lists: pgsql-hackers

Attachments

  Hi,


   


  fix error compile


   


  ----------------


  Кому: Hayato Kuroda (Fujitsu) (kuroda.hayato@fujitsu.com), Masahiko Sawada (sawada.mshk@gmail.com);


  Копия: pgsql-hackers@postgresql.org, orlovmg@gmail.com, amit.kapila16@gmail.com;


  Тема: Patch for migration of the pg_commit_ts directory;


  05.04.2026, 23:27, "ls7777" <ls7777@yandex.ru>:


  
    Hi,
  
  
     
  
  
    I fixed the compiler warnings.
  
  
     
  
  
    
      I want to ask. Do I need to restore replication sources in my patch created by calling the pg_replication_origin_create function?
    
    
      Currently, these replication sources are not being migrated to the new cluster.
    
    
      
        Maybe it should be done later. If there are users who use it.
      
      
         
      
    
  
  
    ----------------
  
  
    Кому: Hayato Kuroda (Fujitsu) (kuroda.hayato@fujitsu.com), Masahiko Sawada (sawada.mshk@gmail.com);
  
  
    Копия: pgsql-hackers@postgresql.org, orlovmg@gmail.com, amit.kapila16@gmail.com;
  
  
    Тема: Patch for migration of the pg_commit_ts directory;
  
  
    21.03.2026, 13:59, "ls7777" <ls7777@yandex.ru>:
  
  
    
      
        Hi,
      
      
         
      
      
        
          The patch has been significantly updated.
        
        
          1. Added the --pg-commit-ts command line key for pg_upgrade.
        
        
          Migration of the pg_commit_ts directory will be performed only if the user explicitly wishes.
        
        
          2. The roident values are being transferred from pg_replication_origin to a new cluster to resolve conflict messages {UPDATE|DELETE}_ORIGIN_DIFFERS.
        
        
           
        
        
          During testing, it turned out that the replication sources created by the pg_replication_origin_create('no_link_sub_4') functions are not migrated to the new cluster. This is probably a bug.
        
        
           
        
        
          The principle of operation: A query to the old cluster generates SQL commands for roident adjustments, which are then executed in the new cluster.
        
        
           
        
      
      
         
      
    
  

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Update copyright for 2026