Re: Good overview of programming IN Postgres?

Guyren, On Tue, Jan 30, 2024 at 12:19 AM Guyren Howe wrote: > Is there a good overview of programming WITHIN Postgres? Not writing code > in client languages that communicates WITH Postgres, but how to take full > advantage of Postgres’ unique programming features — the advanced type > system,

Write Logical Replication Spill Files to different volume

Hello! If I understand it right, the logical replication .spill files in the pg_replslot subfolders are temporary files that need not survive server crashes (as on postgresql restart the WAL senders will delete old spill files, start again reading WAL and regenerate the spill files if

Re: Scriptable way to validate a pg_dump restore ?

On Tue, 30 Jan 2024, 05:02 Adrian Klaver, wrote: > On 1/29/24 11:35, Shaheed Haque wrote: > > > > > > On Tue, 30 Jan 2024, 00:27 Adrian Klaver, > > wrote: > > > > On 1/29/24 10:12, Shaheed Haque wrote: > > > > > > > > > > Yes. But I was under the

Re: Scriptable way to validate a pg_dump restore ?

On Tue, 30 Jan 2024, 05:02 Adrian Klaver, wrote: > On 1/29/24 11:35, Shaheed Haque wrote: > > > > > > On Tue, 30 Jan 2024, 00:27 Adrian Klaver, > > wrote: > > > > On 1/29/24 10:12, Shaheed Haque wrote: > > > > > > > > > > Yes. But I was under the

Re: Monitoring logical replication

This is great, thank you for posting. I'm currently a subcontinent or two away from my dev env, but will compare your approach with mine (you are using some facilities of psql I'm not familiar with). At least you have confirmed that LSNs are the place to start. Thanks again, Shaheed On Tue, 30

Re: building a singularity image from docker hub postgres image

On 2024-01-30 15:52, Allan Kamau wrote: I am trying to build a singularity image from postgres docker image. I am issuing the command below. $ singularity build /local/data/some/postgres.16.1.sif docker://postgres/postgres:16.1 INFO:Starting build... INFO:Fetching OCI image... FATAL: