Re: Need assistance for running postgresql procedures

Thanks, I'll check it out. Regards, Sasmit Utkarsh +91-7674022625 On Wed, 24 Jan, 2024, 01:59 Francisco Olarte, wrote: > Hi sasmit. > > On Tue, 23 Jan 2024 at 18:51, Sasmit Utkarsh > wrote: > > Kindly assist with the issue faced while calling procedures on > postgresql using libpq in C. I have

Providers missing from pgdg-common for GDAL 3.7 (related to multiple missing providers from pgdg-common)

A little while ago this month, this was reported: https://www.spinics.net/lists/pgsql/msg219648.html The issue was fixed for GDAL 3.6, but the same problem still exists for GDAL 3.7, which also needs to be rebuilt against armadillo 12 for rhel 8 (and possibly 9 as well?) This is what I get current

RE: Disk Groups/Storage Management for a Large Database in PostgreSQL

Thanks Olivier and Scot for your inputs! Another data point I would like to share is that VMs will be built in Azure Cloud with Azure Managed Storage and Locally redundant storage (LRS) option with a remote DR as well. LVM or ZFS would still be a good option to allow easy storage/disk manageme

Re: Need assistance for running postgresql procedures

Hi sasmit. On Tue, 23 Jan 2024 at 18:51, Sasmit Utkarsh wrote: > Kindly assist with the issue faced while calling procedures on postgresql > using libpq in C. I have attached all the details in the note. Please let me > know if you need any more information I'm not familiar with using binary p

Re: how to trace a backend session

Hello, I have coded an extension to trace SQL statements for specific backends: https://github.com/pierreforstmann/pg_log_statements (only SQL statements are traced - no wait events data is collected). Pierre Le lun. 22 janv. 2024 à 08:29, James Pang a écrit : > experts, > We migrated our

Need assistance for running postgresql procedures

Hi Postgres Team, Kindly assist with the issue faced while calling procedures on postgresql using libpq in C. I have attached all the details in the note. Please let me know if you need any more information Regards, Sasmit Utkarsh +91-7674022625 In general code flow: main() -> SQL_init_db_connec

Re: Disk Groups/Storage Management for a Large Database in PostgreSQL

Thanks Olivier and Scot for your inputs! Another data point I would like to share is that VMs will be built in Azure Cloud with Azure Managed Storage and Locally redundant storage (LRS) option with a remote DR as well. LVM or ZFS would still be a good option to allow easy storage/disk management

RE: Disk Groups/Storage Management for a Large Database in PostgreSQL

El lun, 22 ene 2024 18:44, Amit Sharma mailto:amitpg...@gmail.com>> escribió: Hi, We are building new VMs for PostgreSQL v15 on RHEL 8.x For a large database of 15TB-20TB. I would like to know from the experts that is it a good idea to create LVMs to manage storage for the database? Or are th