RE: JSONB maximal length ?

Hi Pavel I don’t know what is the value 255MB ? all I know is that I want to insert large pdf documents. I am prevented because of this limit. Best Regards Didier ROS EDF De : pavel.steh...@gmail.com [mailto:pavel.steh...@gmail.com] Envoyé : samedi 28 septembre 2019 18:26 À : ROS Didier

JSONB maximal length ?

Hi By inserting data in a JSONB type column I got the following error message: >> ERROR: string too long to represent as jsonb string DETAIL: Due to an implementation restriction, jsonb strings cannot exceed 268435455 bytes. << could anyone confirm that there is a size limit for JSONB type fi

RE: vaccum in background

Hi It is possible to use background workers with the pg_background extension. Best Regards Didier ROS EDF De : sonams1...@gmail.com [mailto:sonams1...@gmail.com] Envoyé : mercredi 28 août 2019 08:59 À : pgsql-general Objet : Is there any option to run reindex or vaccum in background? Every time

migration of a logical replication configuration

Hi I would like to know the impact of migrating from 10 to 11 the source PostgreSQL cluster of a logical replication configuration? should we also migrate the target PostgreSQL cluster? Or is it possible to setup logical replication from a PostgreSQL 11 instance to a

RE: Table Export & Import

Hi One solution could be to use intel technology: FPGA : https://www.intel.fr/content/www/fr/fr/products/programmable.html the principle is to add an PCI electronic card on the server with CPUs and RAM. this greatly speeds up the loading of the data into the database. Best Regards [cid:image002.

repmgr and automatic failover

Hi It seems that after an automatic failover by repmgr, it is possible to start the old primary instance. ( SPLIT BRAIN Risk) . For example: the case when we make a reboot of the primary server, so there is an automatic failover made by repmgr and in this situation, we end up with 2 primary inst

RE: Postgres Automated Failover

Hi For PostgreSQL Automatic Failover , we are using repmgr too. Best Regards Didier ROS Expertise SGBD DS IT/IT DMA/Solutions Groupe EDF/Expertise Applicative - SGBD -Message d'origine- De : f.pa...@portavita.eu [mailto:f.pa...@portavita.eu] Envoyé : jeudi 17 janvier 2019 15:29 À : pgsq

RE: repmgr and SSH

- De : ian.barw...@2ndquadrant.com [mailto:ian.barw...@2ndquadrant.com] Envoyé : mardi 15 janvier 2019 12:53 À : ROS Didier ; pgsql-general@lists.postgresql.org Objet : Re: repmgr and SSH On 1/14/19 6:29 PM, ROS Didier wrote: > Hi > > I would like to setup a repmgr configuration with one primary node,

repmgr and STONIT - SPLIT BAIN

Hi We are going to implement repmgr according to the following configuration : -Primary node on the site A -Standby node on the site B -Witness node on the same site A Do we need to use LOCATION repmgr parameter in this case to avoid Split Brain and perm

repmgr and SSH

Hi I would like to setup a repmgr configuration with one primary node, one standby node and one witness node. Regarding SSH configuration, the documentation is not clear, I think. Do we need to setup SSH between the three nodes or only between primary and standby no

multiple configurations with repmgr

Hi We are going to use repmgr with one node for the primary, one node for the standby and one node for the witness. It works fine with one project. The problem is that we want to have several other projects. Each one with its own primary node, its own standby node

RE: PostgreSQL 11 and security

..@gmx.net [mailto:karsten.hilb...@gmx.net] Envoyé : vendredi 19 octobre 2018 12:34 À : pgsql-general@lists.postgresql.org Objet : Re: PostgreSQL 11 and security On Fri, Oct 19, 2018 at 10:22:05AM +, ROS Didier wrote: >I would like to know what's new in security with > PostgreS

PostgreSQL 11 and security

Hi I would like to know what's new in security with PostgreSQL 11 Thanks in advance Best Regards Didier ROS Ce message et toutes les pièces jointes (ci-après le 'Message') sont établis à l'intention exclusive des destinataires et les informations qui y

RE: Why the index is not used ?

08:32 +0000, ROS Didier a écrit : > Hi Virendra > You think that outside encryption of the database is the best solution > ? >How do you manage the encryption key ? > Can you give me some examples of this kind of solution. > Best Regards > Didier ROS

RE: Why the index is not used ?

am going to test it. Best Regards Didier ROS De : p...@paulmcgarry.com [mailto:p...@paulmcgarry.com] Envoyé : lundi 8 octobre 2018 00:11 À : ROS Didier Cc : fola...@peoplecall.com; pavel.steh...@gmail.com; pgsql-...@lists.postgresql.org; pgsql-performa...@lists.postgresql.org; pgsql-general

RE: Why the index is not used ?

.com [mailto:tomas.von...@2ndquadrant.com] Envoyé : dimanche 7 octobre 2018 22:08 À : ROS Didier ; fola...@peoplecall.com Cc : pavel.steh...@gmail.com; pgsql-...@lists.postgresql.org; pgsql-performa...@lists.postgresql.org; pgsql-general@lists.postgresql.org Objet : Re: Why the index is not used ? Hi

RE: Why the index is not used ?

s Didier De : greatvo...@gmail.com [mailto:greatvo...@gmail.com] Envoyé : dimanche 7 octobre 2018 21:33 À : ROS Didier Cc : fola...@peoplecall.com; pavel.steh...@gmail.com; pgsql-...@lists.postgresql.org; pgsql-performa...@lists.postgresql.org; pgsql-general@lists.postgresql.org Objet : Re: Why

RE: Why the index is not used ?

< I am interested. Can you give some examples of these encryption function that doesn't salt the data. Best Regards Didier ROS -Message d'origine- De : phil_tnlcz_endec...@chezphil.org [mailto:phil_tnlcz_endec...@chezphil.org] Envoyé : dimanche 7 octobre 2018 21:17 À : ROS Didi

RE: Why the index is not used ?

octobre 2018 18:51 À : ROS Didier Cc : pgsql-...@lists.postgresql.org; pgsql-performa...@lists.postgresql.org; pgsql-general@lists.postgresql.org Objet : Re: Why the index is not used ? Hello Didier, >> (3), (5) to find the match, you decrypt the whole table, apparently this take quite

RE: Why the index is not used ?

ra.ku...@guycarp.com [mailto:virendra.ku...@guycarp.com] Envoyé : dimanche 7 octobre 2018 20:41 À : ROS Didier ; fola...@peoplecall.com Cc : pavel.steh...@gmail.com; pgsql-...@lists.postgresql.org; pgsql-performa...@lists.postgresql.org; pgsql-general@lists.postgresql.org Objet : RE: Why the index is not

RE: Why the index is not used ?

@gmail.com [mailto:greatvo...@gmail.com] Envoyé : dimanche 7 octobre 2018 21:33 À : ROS Didier Cc : fola...@peoplecall.com; pavel.steh...@gmail.com; pgsql-...@lists.postgresql.org; pgsql-performa...@lists.postgresql.org; pgsql-general@lists.postgresql.org Objet : Re: Why the index is not used ? Addition

RE: Why the index is not used ?

t Regards Didier ROS -Message d'origine- De : fola...@peoplecall.com [mailto:fola...@peoplecall.com] Envoyé : dimanche 7 octobre 2018 17:58 À : ROS Didier Cc : pavel.steh...@gmail.com; pgsql-...@lists.postgresql.org; pgsql-performa...@lists.postgresql.org; pgsql-general@lists.postg

RE: Why the index is not used ?

lmcgarry.com] Envoyé : dimanche 7 octobre 2018 04:21 À : ROS Didier Cc : pgsql-...@lists.postgresql.org; pgsql-performa...@lists.postgresql.org; pgsql-general@lists.postgresql.org Objet : Re: Why the index is not used ? I haven’t looked up what pgp_sym_encrypt() does but assuming it does encryption

RE: Why the index is not used ?

f.fr<mailto:support-oracle-nive...@edf.fr> Tél. : 01 78 66 61 14 Tél. mobile : 06 49 51 11 88 Lync : ros.did...@edf.fr De : pavel.steh...@gmail.com [mailto:pavel.steh...@gmail.com] Envoyé : samedi 6 octobre 2018 12:14 À : ROS Didier Cc : pgsql-...@lists.postgresql.org; pgsql-performa...@lists.po

Why the index is not used ?

Hi I would like to submit the following problem to the PostgreSQL community. In my company, we have data encryption needs. So I decided to use the following procedure : (1)Creating a table with a bytea type column to store the encrypted data CREATE TABLE cartedecredit(card_id SERIAL PRIMARY

RE: increasing HA

Hi I have made a lot of PostgreSQL High Availability tests (more than 20 by solution) and the two following products respond well to the need : (1)Repmgr (2ndQuadrant) (2)Pglookout (aiven) About PAF, the product is hard to install and set up . It need a linux cluster and

PostgreSQL : encryption with pgcrypto

Hi Regarding the encryption of data by pgcrypto, I would like to know the recommendations for the management of the key. Is it possible to store it off the PostgreSQL server? Is there the equivalent of Oracle "wallet" ? Thanks in advance