Re: pg 16.4, logical replication, use case = data archiving

eplication feature ? On Tue, Aug 20, 2024 at 7:26 AM milist ujang wrote: > Hi all, > > I Play logical replication with row filter feature, my use case is data > archiving. > in lab env, it worked, my questions: > - during alter subscription, what about on-going DML? Can it

pg 16.4, logical replication, use case = data archiving

Hi all, I Play logical replication with row filter feature, my use case is data archiving. in lab env, it worked, my questions: - during alter subscription, what about on-going DML? Can it be lost? - any lock during alter subscription should I aware? scenario: # on source tutorial=# ALTER PUBL

Re: signal 11: Segmentation fault ; query constraint list; pg16.3

[7f318b0a4000+ee000] likely on CPU 93 (core 1, socket 1) after dropping the citus extension, now it's OK. Thanks for the reply. On Mon, May 20, 2024 at 6:01 PM David Rowley wrote: > On Mon, 20 May 2024 at 22:32, milist ujang wrote: > > > > postgres 16.1; rocky 9.3 > > &g

signal 11: Segmentation fault ; query constraint list; pg16.3

postgres 16.1; rocky 9.3 when connect to database postgres this query is OK, but run on user database, got segmentation fault. 2024-05-20 17:16:54.942 WIB,,,134291,,6648420a.20c93,165,,2024-05-18 12:52:10 WIB,,0,LOG,0,"server process (PID 487952) was terminated by signal 11: Segmentation fau

db was corrupted, ERROR: cannot freeze committed xmax; fix by deleting rows in catalog tables

Hi all, I have a case on pg12.9 - rhel8 which crashed a long time ago and now in log keep saying: automatic vacuum of table "dbnamexx.pg_catalog.pg_statistic"automatic vacuum of table "dbnamexx.pg_catalog.pg_class"automatic vacuum of table "dbnamexx.pg_toast.pg_toast_2619" automatic vacuum of ta

Re: Postgres to edb AS, need conversion?

So, do I have to perform conversion/migration? On Thursday, November 3, 2022, Abdul Sayeed wrote: > After migration you need to execute below command from SQL Prompt: > > > > vacuum (verbose, analyze); --> to update statistics. > > Rest is good. > > > Regards, > Abdul Sayeed > > > -- > Thanks

Postgres to edb AS, need conversion?

Hi all, Anyone have experiences or someone from edb can guid about change engine from postgres open source to edb as, di I need to convert the data or simply plug-and-play? Or need run a tool to add catalog table owned by edb as? -- regards ujang jaenudin | DBA Consultant (Freelancer) http://o

does postgres has snapshot standby feature?

hi all, read about removing standby.signal file behavior in pg14 from https://dbaclass.com/article/how-to-open-postgres-standby-database-for-read-writesnapshot-standby/ I was shocked about the hidden feature of snapshot standby, does it really exist? I could not find anything about snapshot stand

Re: ERROR: catalog is missing 3 attribute(s) for relid 150243

On Fri, Aug 19, 2022 at 11:02 AM Julien Rouhaud wrote: > Hi, > > Please don't top-post on this list (and please trim quoted messages too). > > > > No, this function is comparing pg_class.relnatts to rows fetched querying > pg_attribute for the given relation. > > any concern if I update pg_class.

Re: ERROR: catalog is missing 3 attribute(s) for relid 150243

8, 2022 at 5:33 PM milist ujang wrote: > Hi lists, > > I have an index anomaly on a table; getting the error as subject. > > dumping queries behind \dS+ of a table, got 4 queries (see detail below) > 1st query --> OK > 2nd query --> OK > 3rd query ERROR same as subj

ERROR: catalog is missing 3 attribute(s) for relid 150243

Hi lists, I have an index anomaly on a table; getting the error as subject. dumping queries behind \dS+ of a table, got 4 queries (see detail below) 1st query --> OK 2nd query --> OK 3rd query ERROR same as subject (ERROR: catalog is missing 3 attribute(s) for relid 150243) comment on 3rd query

Re: pglogical 2.3.2 on 9.4 --> 12.3 CONFLICT: remote DELETE (tuple not found). Resolution: skip.

orrect error message for the data type char? On Wed, Aug 12, 2020 at 10:50 AM milist ujang wrote: > Configured pglogical source is 9.4 target is 12.3 > > a table has PK from multiple column (varchar(50),char(2),char(1)). > > initial syncronization is OK, but when at source ther

pglogical 2.3.2 on 9.4 --> 12.3 CONFLICT: remote DELETE (tuple not found). Resolution: skip.

Configured pglogical source is 9.4 target is 12.3 a table has PK from multiple column (varchar(50),char(2),char(1)). initial syncronization is OK, but when at source there is delete , but got error at target... LOG: CONFLICT: remote DELETE on relation public.a_ replica identity index a_XXX_

BDR: remove junk replication identifier

Hi all, I had many waste replication identifier (164 of 457), the env is BDR 0.9.3 and 9.4.4. I'm going to remove those junk replication identifiers, but there is no exactly how to do in docs. # select slot_name,plugin,datoid,restart_lsn from pg_replication_slots where slot_name like '%654018%';

Re: [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory

Hi craig, I have a bunch of orphaned replication identifier. How to cleanup those orpaned identifier without affecting currently configured slots? I mean what is relation the replication identifier with slot_name in replication slots? On Mon, Sep 18, 2017 at 3:00 PM, milist ujang wrote