Migration of Oracle Vault to Postgres

2023-09-21 Thread Elango Thiagarajan
Hi Folks, We are planning to migrate Oracle Enterprise edition to Azure Postgresql. Our oracle database is guarded by Oracle Vault. Do we have similar security on Postgres. Any Whitepapers on how to migrate vault to Postgres. Thanks in Advance. Regards, Elango T

How to fork pg_dump or psql w/o leaking secrets?

2023-09-21 Thread Dominique Devienne
Hi. To administer our PostgreSQL-based system, we have custom tools to manage the schemas, load data, etc... Including a versatile CLI tool. But that tool is special purpose, while sometimes we want/need the general purpose PSQL. But because our ROLE and SCHEMA names are rather long and unwieldly,

Re: whether I can add a new encoding?

2023-09-21 Thread Tom Lane
"=?ISO-8859-1?B?UGFuZG9yYQ==?=" writes: > The pg_wchar.h file comments "We must avoid renumbering any backend encoding > until libpq's major version number is increased beyond 5", Can I add a new > server-side encoding, GBK18030, and place it after PG_KOI8U in PG10.6? What is GBK18030? If it's

Re: whether I can add a new encoding?

2023-09-21 Thread Tatsuo Ishii
> The pg_wchar.h file comments "We must avoid renumbering any backend encoding > until libpq's major version number is increased beyond 5", Can I add a new > server-side encoding, GBK18030, and place it after PG_KOI8U in PG10.6?  What's GBK18030? Can you please give a pointer to a specification

whether I can add a new encoding?

2023-09-21 Thread Pandora
The pg_wchar.h file comments "We must avoid renumbering any backend encoding until libpq's major version number is increased beyond 5", Can I add a new server-side encoding, GBK18030, and place it after PG_KOI8U in PG10.6? 

Re: Changed functionality from 14.3 to 15.3

2023-09-21 Thread Laurenz Albe
On Wed, 2023-09-20 at 14:24 -0700, David G. Johnston wrote: > On Wed, Sep 20, 2023 at 2:20 PM Erik Wienhold wrote: > > Has your 14.3 some left-over state from previous test runs?  I assume > > the server is not re-created for each test run.  I was wondering if the > > roles may still exist and wit