Re: Support logical replication of DDLs

Isn't it a good idea to move triggers to CreateReplicationSlot() ? as create publication also create replication slot, AFAIK. thanks Rajesh On Tue, Nov 29, 2022 at 10:35 AM rajesh singarapu wrote: > > Thanks Ajin for the clarification. > > This is really a helpful feature. &

Re: Support logical replication of DDLs

Thanks Ajin for the clarification. This is really a helpful feature. On Tue, Nov 29, 2022 at 10:14 AM Ajin Cherian wrote: > > On Tue, Nov 29, 2022 at 3:39 PM rajesh singarapu > wrote: > > > > Thanks Ajin for the reply. > > > > We "Create/Install" th

Re: Support logical replication of DDLs

g')" we would not install these triggers in the system, so we dont get DDLs decoded, right ? I am a bit new to this postgres, is there anything missing in my understanding ? thanks Raejsh On Tue, Nov 29, 2022 at 9:55 AM Ajin Cherian wrote: > > On Tue, Nov 29, 2022 at 1:29 PM ra

Re: Support logical replication of DDLs

One question, I understand that we create/enable triggers on create publication command flow. I am wondering how this works in case of logical replication using slots. thanks Rajesh On Mon, Nov 28, 2022 at 10:17 AM Zheng Li wrote: > > > > > > > > > 1. CREATE TABLE LIKE > > > > I found that t

Re: Use proc instead of MyProc in ProcArrayGroupClearXid()/TransactionGroupUpdateXidStatus()

Thanks Bharat and Amit for the review and explaining rationale. for the TransactionGroupUpdateXidStatus() change, let me see if I can piggy back this change on something more valuable. thanks Rajesh On Tue, Nov 8, 2022 at 11:58 AM Amit Kapila wrote: > > On Mon, Nov 7, 2022 at 3:17 PM

Use proc instead of MyProc in ProcArrayGroupClearXid()/TransactionGroupUpdateXidStatus()

Hi, In both TransactionGroupUpdateXidStatus and ProcArrayGroupClearXid global MyProc is used. for consistency, replaced with a function local variable. thanks Rajesh v1-0001-Use-proc-instead-of-MyProc-in-ProcArrayGroupClear.patch Description: Binary data

Re: Enforce "max_wal_size/ min_wal_size must be at least twice wal_segment_size" limit while setting GUCs

Hi Bharath, Could you explain why min wal size must be at least twice but not equal to wal_segment_size ? thanks Rajesh On Sat, May 21, 2022 at 7:08 PM Bharath Rupireddy wrote: > > Hi, > > Currently postgres allows setting any value for max_wal_size or > min_wal_size, not enforcing "at least tw

Re: Support logical replication of DDLs

+ On Sun, Mar 13, 2022 at 5:05 PM Dilip Kumar wrote: > > On Mon, Feb 21, 2022 at 9:43 PM Zheng Li wrote: > > > > Hello, > > > > One of the most frequently requested improvements from our customers > > is to reduce downtime associated with software updates (both major and > > minor versions). To

Postgres Replication from windows to linux

Hi Hackers, I am trying to migrate my postgres to linux, as we are moving away from windows. I am trying both dump/restore and logical decoding, but people are not happy with performance. Is there a way/tooling I can use around WAL shipping/physical replication here ? thanks Rajesh

Re: Converting WAL to SQL

Thanks much for your suggestions, I am exploring logical decoding because I have two different platforms and versions as well. So my best bet is logical decoding, but I am also wondering if somebody has done replication/migration from windows to linux or vise-a-versa at physical level with some too

Converting WAL to SQL

Hi Hackers, I am wondering if we have a mechanism to convert WAL records to SQL statements. I am able to use logical decoders like wal2json or test_decoding for converting WAL to readable format, but I am looking for a way to convert WAL to sql statements. Thanks Rajesh