Migration Oracle multitenant database to PostgreSQL ?

Hi I would like to know if it is possible to migrate Oracle multitenant database (with multiple PDB) to PostgreSQL ? Thanks in advance Best Regards D ROS EDF Ce message et toutes les pièces jointes (ci-après le 'Message') sont établis à l'intention exclusive des destinataires et les

PostgreSQL and Flashback Database

Hi My company is looking for a team of developers to implement the "flashback database" functionality in PostgreSQL. Do you think it's feasible to implement? how many days of development? Thanks in advance Best Regards Didier ROS E.D.F Ce message e

PostgreSQL and TLS 1.2

Hi I would like to check that postgresql is compatible with TLS 1.2. what test could I do to check this compatibility? Thanks in advance Best Regards Didier ROS EDF Ce message et toutes les pièces jointes (ci-après le 'Message') sont établis à l'intention exclusive des destinataires et l

PostgreSQL and Real Application Testing (RAT)

Hi In my business, one of the things blocking the migration from Oracle to PostgreSQL is not having the equivalent of Oracle Real Application Testing . This product captures a charge in production and replay it in a test environment. this allows to know the impacts of a migration to a newer vers

RE: get_database_name() from background worker

Hi I would like to know : Are you using pg_background extension to work with backgroud workers ? Thanks in advance Best Regards Didier ROS Expertise SGBD EDF - DTEO - DSIT - IT DMA -Message d'origine- De : tsunakawa.ta...@fujitsu.com [mailto:tsunakawa.ta...@fujitsu.com

RE: get_database_name() from background worker

So, What are you using to create background workers ? Can you show me an extract of your code ? TIA Best Regards Didier De : koi...@2ndquadrant.com [mailto:koi...@2ndquadrant.com] Envoyé : mercredi 11 décembre 2019 09:16 À : ROS Didier Cc : tsunakawa.ta...@fujitsu.com; pgsql-hackers

RE: get_database_name() from background worker

origine- De : tsunakawa.ta...@fujitsu.com [mailto:tsunakawa.ta...@fujitsu.com] Envoyé : jeudi 12 décembre 2019 02:04 À : 'Koichi Suzuki' Cc : ROS Didier ; pgsql-hackers@lists.postgresql.org Objet : RE: get_database_name() from background worker From: Koichi Suzuki > I'm not usin

problem with read-only user

ose new tables. Anybody can help to solve this problem ? Thank you in advance Didier ROS didier@edf.fr 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 figurent sont stri

RE: problem with read-only user

will not have the rights to read them. Kidsdpn03_ro must be explicitly granted read rights on this objects. Can you confirm that if it was the kidsdpn03_ro role that created the tables, there would be no problem when accessing new tables? Thanks in advance. Didier ROS didier@e

PostgreSQL and big data - FDW

Hi I would like to use a Foreign Data Wrapper (FDW) to connect to a HADOOP cluster which uses KERBEROS authentication. is it possible to achieve this ? which FDW should be used ? Thanks in advance Best Regards Didier ROS EDF Ce message et toutes les pièces jointes (ci-après le 'Message') sont

RE: PostgreSQL and big data - FDW

re of that ? Could EDB make a clear statement on this point? If so, how to implement this method ? is there any document on this subject ? Thanks in advance. Best Regards Didier ROS didier@edf.fr Tél. : +33 6 49 51 11 88 -Message d'origine- De : br...@momjian.us [mailto:b

RE: PostgreSQL and big data - FDW

-- De : sfr...@snowman.net [mailto:sfr...@snowman.net] Envoyé : mercredi 24 juin 2020 18:53 À : Bruce Momjian Cc : ROS Didier ; pgsql-hackers@lists.postgresql.org Objet : Re: PostgreSQL and big data - FDW Greetings, * Bruce Momjian (br...@momjian.us) wrote: > On Wed, Jun 24, 2020 at 09:05:30

open-source equivalent of golden-gate

Hi In the Oracle world we use the product "golden gate" to execute transactions from a source database (Oracle, Mysql) to a PostgreSQL instance. This allows 2 Oracle and PostgreSQL databases to be updated at the same time in real time. I would like to know if there is an equivalent open-source pr

RE: Bulk Insert into PostgreSQL

Hi I suggest to split the data to insert into several text files ( the number of CPUs) , create extension pg_background, and create a main transaction which calls x (number of CPUs) autonomous transactions. Each one insert the data from a specific test file via the

How to use public key file to encrypt data

Hi I Would like to know how to encrypt data with physical public key files. I can't find any documentation about this subject. Thanks in advance Best Regards [cid:image002.png@01D14E0E.8515EB90] Didier ROS Expertise SGBD DS IT/IT DMA/Solutions Groupe EDF/Expertise

unsubscribe pgsql-hack...@postgresql.org

[cid:image001.png@01D3608D.8F5DC9E0] Didier ROS DSP/CSP IT-DMA/Solutions Groupe EDF/Expertise Applicative Expertise SGBD 32 Avenue Pablo Picasso 92000 NANTERRE Ce message et toutes les pièces jointes (ci-après le 'Message') sont établis à l'intention exclusive des destinataires et les inform

impact of SPECTRE and MELTDOWN patches

Hi I would like to know what are the recommandation to resolve the problem of performance impact after applying the SPECTRE and MELTDOWN patches ? Do we have to add more CPUs ? NB : I have tested on one of our production database and I get an impact o

RE: impact of SPECTRE and MELTDOWN patches

DMA/Solutions Groupe EDF/Expertise Applicative - SGBD Nanterre Picasso - E2 565D (aile nord-est) 32 Avenue Pablo Picasso 92000 Nanterre didier@edf.fr<mailto:didier@edf.fr> De : tony.r...@atos.net [mailto:tony.r...@atos.net] Envoyé : vendredi 21 septembre 2018 11:24 À : ROS Didier ;

RE: impact of SPECTRE and MELTDOWN patches

88 Lync : ros.did...@edf.fr De : tony.r...@atos.net [mailto:tony.r...@atos.net] Envoyé : vendredi 21 septembre 2018 11:48 À : ROS Didier ; pgsql-hack...@postgresql.org Objet : RE: impact of SPECTRE and MELTDOWN patches Thx. So, it isIntel HW. Have you experimented too with Power HW? Rega