Re: txid_current vs xact_commit stats

2024-10-08 Thread Laurenz Albe
On Wed, 2024-10-09 at 04:22 +, senor wrote: > I was under the impression that all transactions must end with a commit or a > rollback but watching stats doesn't support this. Web searches tend to return > info on what a transaction is or the ratio of commits to rollbacks. I found > nothing cont

txid_current vs xact_commit stats

2024-10-08 Thread senor
HI All; I was under the impression that all transactions must end with a commit or a rollback but watching stats doesn't support this. Web searches tend to return info on what a transaction is or the ratio of commits to rollbacks. I found nothing contradicting what I think I know. I've sampled

Availability of ogr fdw in repository for RHEL 9 / Rocky Linux

2024-10-08 Thread Bill Mische
I see the source rpm for the ogr_fdw_17 extension for Rocky Linux 9, but the installation rpm is unavailable. Is this something we build ourselves, or will it be available soon? Thanks, William Mische

Re: backup

2024-10-08 Thread Andy Hartman
Thanks, I'll check it out. On Mon, Oct 7, 2024 at 11:25 PM Muhammad Usman Khan wrote: > > Hi, > You can refer the following: > Automating PostgreSQL Backups with Python Using pg_basebackup | by Usman > Khan | Sep, 2024 | Medium >

Re: libpq5 error

2024-10-08 Thread Devrim Gündüz
Hi, On Mon, 2024-10-07 at 08:44 -0700, Adrian Klaver wrote: > > Unknown Error occurred: Transaction test error:\n file > > /usr/share/pgsql/postgres.bki from install of > > libpq5-17.0-42PGDG.rhel9.x86_64 conflicts with file from package > > postgresql-server-15.8-1.module+el9.4.0+25512+c6b50a4