Re: Help in vetting error using "pg_upgrade" - steps for Postgres DB upgrade from Ver 13.X to ver 15.X

2025-01-24 Thread Adrian Klaver
On 1/24/25 10:01 AM, Bharani SV-forum wrote: Adrian Thanks This is the exact error which the system admin is facing  postgresql15-contrib installation on Amazon Linux 2 fails on Python shared lib dependency Which from your post the admin said was due to: "His version is "It needs li

Re: Help in vetting error using "pg_upgrade" - steps for Postgres DB upgrade from Ver 13.X to ver 15.X

2025-01-24 Thread Bharani SV-forum
AdrianThanks This is the exact error which the system admin is facing  postgresql15-contrib installation on Amazon Linux 2 fails on Python shared lib dependency "https://www.postgresql.org/message-id/CABUevEz_OHR%2BaGU%2B7yuhpfJD%2BeWgC8aHgVRjP5U30kJqu%2B7jmg%40mail.gmail.com"; On Friday, J

Re: Help in vetting error using "pg_upgrade" - steps for Postgres DB upgrade from Ver 13.X to ver 15.X

2025-01-24 Thread Adrian Klaver
On 1/24/25 07:50, Bharani SV-forum wrote: Team Need your additional input. VM is based on EC2 OS Version = Amazon Linux 2 Existing DB version = 13.X - Pg Community under EC2 - VM (Same VM) Target DB version = 15.x  - Pg Community under EC2 - VM (Same VM) i will narrate the latest error execut

Help in vetting error using "pg_upgrade" - steps for Postgres DB upgrade from Ver 13.X to ver 15.X

2025-01-24 Thread Bharani SV-forum
TeamNeed your additional input.VM is based on EC2 OS Version = Amazon Linux 2  Existing DB version = 13.X - Pg Community under EC2 - VM (Same VM)Target DB version = 15.x  - Pg Community under EC2 - VM (Same VM) i will narrate the latest error executing: SELECT pg_catalog.set_config('search_path

Re: Is postgresql's json strong consistency or eventually consistency?

2025-01-24 Thread Torsten Förtsch
On Fri, Jan 24, 2025 at 4:48 AM anlex N wrote: > Hello Adrian, Laurenz. Have you tried postgresql's json in your everyday > life? How fast is it? how is it than mongodb? > My honest opinion, JSON(B) in PG is great as data transfer format but not so much for storage. Here is an example. Up to las

Re: Is postgresql's json strong consistency or eventually consistency?

2025-01-24 Thread Torsten Förtsch
On Thu, Jan 16, 2025 at 2:02 PM Laurenz Albe wrote: > On Thu, 2025-01-16 at 15:25 +0300, anlex N wrote: > > I have searched all archives, but have no results. Please help me. > > That's probably because the question doesn't make much sense. > A single PostgreSQL instance (=cluster) enforces consi