Re: PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8
On Wed, Aug 23, 2023 at 6:23 AM Tushar Takate wrote: > Hi Team, > > We want to know if there are any open/known issues that we may face > post-migration of the DB cluster from centos7/RHEL7/OEL7 to RHEL8. > > Depends on the method you choose to perform this migration ? If you are using pg_dump and pg_restore for the initial data copy, followed by logical replication, then, it should be technically okay. > We came across one issue regarding collation( > https://wiki.postgresql.org/wiki/Locale_data_changes), the solution for > which is to reindex or use logical replication. In a similar way, we want > to understand if there are any other known issues that the community should > be aware of. > > - > Thanks & Regards, > Tushar K Takate. > > -- Regards, Avinash Vallarapu
Re: Ora2pg Delta Migration: Oracle to PostgreSQL
Hi, Has anyone tried delta/incremental data migration for Oracle to PostgreSQL > using Ora2pg? Or what are the best options to run delta migration for > Oracle to PostgreSQL? There are a few ways of dealing with it when using Ora2Pg. *Option 1 : *Ora2Pg configuration file allows us to pass the conditions(predicates) to be applied to a table while migrating the data from a table. So, if there is a way to filter the data since the last full load, you can pass the condition to the configuration file, for each table. This is some work for sure but it works great if you are able to identify those conditions such as creation_date or last_updated_date, let's say. *Option2 :* Ora2Pg is currently CDC ready. What this means is that, Ora2Pg can provide the SCN at which the table copy has been initiated. Technically, we provide the SCN to the CDC tools or custom CDC techniques to continue replication since that SCN. *Option 2.1 :* Leverage Debezium, an Open Source solution to perform continuous replication from Oracle to PostgreSQL from the SCN produced by Ora2Pg for that table. So, it is all about Ora2Pg + Debezium It might be initially challenging, but you will get there. Regards, Avi Vallarapu, CEO, HexaCluster Corp. On Fri, May 3, 2024 at 3:25 AM Muhammad Ikram wrote: > Hi, > > Not related to Ora2PG but in the past I have used the EDB Migration > toolkit for such scenarios. Filterprops option can help in specifying > filter (where clause). > > Regards, > Ikram > > > On Fri, May 3, 2024 at 8:12 AM Ron Johnson > wrote: > >> On Thu, May 2, 2024 at 8:28 PM Amit Sharma wrote: >> >>> Hello, >>> >>> Has anyone tried delta/incremental data migration for Oracle to >>> PostgreSQL using Ora2pg? Or what are the best options to run delta >>> migration for Oracle to PostgreSQL? >>> >> >> What do the ora2pg docs say about whether or not that feature is >> implemented? (It wasn't when I last used it in 2022.) >> >> > > > -- > Muhammad Ikram > >
Re: Planet Postgres and the curse of AI
Hi, As someone who has taken days to publish each blog upon so many reviews, corrections and edits while attempting to make it as best/informative and as perfect as possible, it might seem slightly frustrating when we see some AI generated content, especially when it is misleading readers. However, I do agree with Lawrence that it is impossible to prove whether it is written by AI or a human. AI can make mistakes and it might mistakenly point out that a blog is written by AI (which I know is difficult to implement). I see Moderators spending some time reviewing content and accepting or warning if it is not related to Postgres. AI may be adopted to help us score whether an article is related to Postgres and decline the submission/blog feed. But, it is very impossible to use AI or some strategy to identify whether it is written by AI or human. People may also use AI generated Images in their blogs, and they may be meaningful for their article. Is it only the content or also the images ? It might get too complicated while implementing some rules. Ultimately, Humans do make mistakes and we shouldn't discourage people assuming it is AI that made that mistake. On Tue, Jul 23, 2024 at 11:51 AM Laurenz Albe wrote: > On Tue, 2024-07-23 at 10:38 -0400, Greg Sabino Mullane wrote: > > > Why not say that authors who repeatedly post grossly counterfactual or > > > misleading content can be banned? > > > > Perhaps as you hint at, we need a policy to not just discourage > AI-generated > > things, but also wrong/misleading things in general > > I have been known to make mistakes in my blogs... > We shouldn't discourage people who happen to blog something wrong. > That's why I used strong verbiage like "grossly counterfactual". > > Yours, > Laurenz Albe > > > -- Regards, Avinash Vallarapu
