Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

Hi, Adrian. I'm arranging a test program with two nested cursors in two versions: 1. 4Js Genero BDL language 2. pure C with libpq language I'll put both programs in stress execution into the production environment looking for some hours how they behaves. Possible combinations are: 1. no-one t

Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org

On 12/24/24 01:28, Matthias Leisi wrote: I installed Postgres 16/17 from apt.postgresql.org  (with the intent of using version 17) on Debian 12/Bookworm. Both have the same version of repmgr: postgres@dev-pgcl01:~$ /usr/lib/postgresql/17/bin/repmgr  --version repmgr

Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org

Matthias Leisi writes: >> This [HINT] says that YOU are supposed to run the ALTER EXTENSION command: > I did run that, but it seemed to have no effect. How should the update work, > what should it do? What this suggests is that you have a repmgr executable (.so file) that is newer than the exte

Re: "trailing junk after numeric literal at or near ""512"""

Olleg Samoylov writes: > I have PostgreSQL 16.6. The log files are attached as partitions by > file_fdw to the SQL table. Common practice. But after the error message > "trailing junk after numeric literal at or near ""512""" (vim -b view) > was wrote, the reading all log was stopped with error f

Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org

> > This [HINT] says that YOU are supposed to run the ALTER EXTENSION command: > [quote] > update the installed extension version by executing "ALTER EXTENSION repmgr > UPDATE" > [/quote] I did run that, but it seemed to have no effect. How should the update work, what should it do? — Matthia

Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org

On Tue, Dec 24, 2024 at 4:28 AM Matthias Leisi wrote: > I installed Postgres 16/17 from apt.postgresql.org (with the intent of > using version 17) on Debian 12/Bookworm. Both have the same version of > repmgr: > > postgres@dev-pgcl01:~$ /usr/lib/postgresql/17/bin/repmgr --version > repmgr 5.5.0

repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org

I installed Postgres 16/17 from apt.postgresql.org (with the intent of using version 17) on Debian 12/Bookworm. Both have the same version of repmgr: postgres@dev-pgcl01:~$ /usr/lib/postgresql/17/bin/repmgr --version repmgr 5.5.0 postgres@dev-pgcl01:~$ /usr/lib/post