Re: How you make efficient design for CDC and book marking

If you are worried about the audit trigger and also an additional audit table to hold all the rows , then you may get an additional flag added to your base table deleted_flag and when delete happens, you just need to update that flag through your code manually, but not physically delete the record

Re: Preallocation changes in Postgresql 16

On Fri, Apr 26, 2024 at 4:37 AM Riku Iki wrote: > I am wondering if there were preallocation related changes in PG16, and if it > is possible to disable preallocation in PostgreSQL 16? I have no opinion on the btrfs details, but I was wondering if someone might show up with a system that doesn't

How you make efficient design for CDC and book marking

Hello, My understanding is that the replication tools normally rely on the database transaction logs to find the CDC/delta changes(Insert/Update/Delete) for tables and then move those delta changes to the target system/databases. Whatever may be the source database (It might be open source postgres

Re: Need some assistance on stored procedures execution using libpq in C

čt 25. 4. 2024 v 18:46 odesílatel Sasmit Utkarsh napsal: > Hi Pavel, > > Thanks for the info. But is it not possible to have some kind of handling > of an empty result set using libpq for the given procedure? > extension dblink uses libpq (to connect to other databases or servers). You can check

Re: Need some assistance on stored procedures execution using libpq in C

Hi Pavel, Thanks for the info. But is it not possible to have some kind of handling of an empty result set using libpq for the given procedure? Regards, Sasmit Utkarsh +91-7674022625 On Thu, Apr 25, 2024 at 8:26 PM Pavel Stehule wrote: > Hi > > čt 25. 4. 2024 v 12:57 odesílatel Sasmit Utkars

Preallocation changes in Postgresql 16

Hi, We have PostgreSQL server, which currently runs PostgreSQL 15 on compressed btrfs. I tried to migrate DB to PostgreSQL 16, and found that data is not being compressed for PostgreSQL 16 server. One of the possible reason why btrfs won't compress data is data preallocation. When running "comps

Re: best migration solution

Hello Markus, keep it simple. Use a restored backup of the source db or this db itself and then Am 25.04.2024 um 09:55 schrieb Zwettler Markus (OIZ): we have to migrate from hosted PG12 to containerized PG16 on private cloud. some of the installed PG12 extensions are not offered on the contai

Re: Need some assistance on stored procedures execution using libpq in C

Hi čt 25. 4. 2024 v 12:57 odesílatel Sasmit Utkarsh napsal: > Hi PostgreSQL Team, > > I'm trying to execute the stored procedure(details along with the program > in the attachment) to fetch the records from the table for the inputs given > in the code as well. I have already created the procedur

Re: What linux version to install ?

On 4/25/24 00:46, Kashif Zeeshan wrote: I worked with both CentOS/RHEL 7/8. What does the above mean relative to the original question? -- Adrian Klaver adrian.kla...@aklaver.com

Re: best migration solution

On Thu, Apr 25, 2024 at 3:55 AM Zwettler Markus (OIZ) < markus.zwett...@zuerich.ch> wrote: > we have to migrate from hosted PG12 to containerized PG16 on private > cloud. > > > > some of the installed PG12 extensions are not offered on the containerized > PG16, eg. PostGIS related extensions like

Need some assistance on stored procedures execution using libpq in C

Hi PostgreSQL Team, I'm trying to execute the stored procedure(details along with the program in the attachment) to fetch the records from the table for the inputs given in the code as well. I have already created the procedure in the db. But I see some strange output when I try to fetch the detai

Re: could not open file "global/pg_filenode.map": Operation not permitted

Hi Nick On Thu, Apr 25, 2024 at 12:56 PM Nick Renders wrote: > Hello, > > We have a Postgres server that intermittently logs the following: > > 2024-02-26 10:29:41.580 CET [63962] FATAL: could not open file > "global/pg_filenode.map": Operation not permitted > 2024-02-26 10:30:11.147 CET [90610

Re: best migration solution

On Thu, Apr 25, 2024 at 12:55 PM Zwettler Markus (OIZ) < markus.zwett...@zuerich.ch> wrote: > we have to migrate from hosted PG12 to containerized PG16 on private > cloud. > > > > some of the installed PG12 extensions are not offered on the containerized > PG16, eg. PostGIS related extensions like

best migration solution

we have to migrate from hosted PG12 to containerized PG16 on private cloud. some of the installed PG12 extensions are not offered on the containerized PG16, eg. PostGIS related extensions like pg_routing and ogr_fdw. some of these extensions are not needed anymore. some of these extensions were

Re: What linux version to install ?

On Thu, Apr 25, 2024 at 12:45 PM Adrian Klaver wrote: > On 4/2/24 16:53, David Gauthier wrote: > > This is what we are running... > > Red Hat Enterprise Linux Server release 7.9 (Maipo) > > > > In our pandora distrib, I see PG v15.3. I was wondering if there is > > something even better. Can't s