Re: As a Linux distro, how to package multiple postgres major versions?

2021-11-25 Thread Laurent FAILLIE
Hello, Which distribution are you speaking about ? I'm using Gentoo and postgresql is versioned : you install the versions you're looking for and switch form one to another using eselect laurent@torchwood ~ $ eselect postgresql list Available PostgreSQL Slots   11    11.7   12

Re: Looking for some help with HA / Log Log-Shipping

2021-03-31 Thread Laurent FAILLIE
Replying to myself :) It seems pg_basebackup did all the tricks, even restarting the slave. And it is in standby mode.Do I have anything to do in addition ? Thanks Le mercredi 31 mars 2021 à 12:51:29 UTC+2, Laurent FAILLIE a écrit : Hello, We are running Postgresql 12 and I'm t

Looking for some help with HA / Log Log-Shipping

2021-03-31 Thread Laurent FAILLIE
Hello, We are running Postgresql 12 and I'm trying to put in place streaming wal replication. I followed officiale documentation ( https://www.postgresql.org/docs/12/warm-standby.html ) as well as this tutorial : https://scalegrid.io/blog/managing-high-availability-in-postgresql-part-1/  

Re: Clustering solution ?

2020-07-15 Thread Laurent FAILLIE
Hello all, thanks all for your replies : I started to learn Patroni.Anyway, any alternative with my customer want's also LoadBalancing ? Thanks Laurent Le jeudi 9 juillet 2020 à 17:47:23 UTC+2, Laurent FAILLIE a écrit : Mainly for HA and DR but it can help also for the future

Re: Clustering solution ?

2020-07-09 Thread Laurent FAILLIE
Mainly for HA and DR but it can help also for the future if a load balancing is possible. But it's not mandatory yet. Thanks Le jeudi 9 juillet 2020 à 17:30:35 UTC+2, Ron a écrit : For high availability, for load sharing or for disaster recovery? On 7/9/20 8:53 AM, Laurent FA

Clustering solution ?

2020-07-09 Thread Laurent FAILLIE
Hello, I've been asked by one of my customer to know which are the possible clustering solution for PostgreSQL ? Active/passive ?Active/active ? if possible free or not too expensive. Thanks Laurent

pg_dump: ERROR: array size exceeds the maximum allowed (268435455)

2018-12-10 Thread Laurent FAILLIE
Hello, I'm trying to save a database from a dying disk on a Gentoo/Linux box. Unfortunately, when I'm issuing a $ pg_dumpall --clean I got pg_dump: [programme d'archivage (db)] échec de la requête : ERROR:  array size exceeds the maximum allowed (268435455) pg_dump: [programme d'archivage (db)]