Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?

[Marc Millas]

Hi Thomas,

to my understanding, there is ONE master key for TDE in 12c.

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com



On Sun, May 21, 2023 at 9:47 PM Thomas Kellerer  wrote:

>
> Marc Millas schrieb am 21.05.2023 um 13:13:
> > Oracle have One (1) DB per instance (in Oracle its not named a cluster
> as...there is only one !). So ...
>
> Oracle can have multiple (pluggable) databases per instance since Oracle 12
>
>
>
>

Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?

[Theodore M Rolle, Jr.]

Yes, the SQLite thing.

On Sun, May 21, 2023, 15:11 Marc Millas  wrote:

> ?? the sqlite thing ??
>
> Marc MILLAS
> Senior Architect
> +33607850334
> www.mokadb.com
>
>
>
> On Sun, May 21, 2023 at 7:15 PM Theodore M Rolle, Jr. 
> wrote:
>
>> What about sqlcipher?
>>
>> On Sun, May 21, 2023, 07:16 Marc Millas  wrote:
>>
>>> Oracle have One (1) DB per instance (in Oracle its not named a cluster
>>> as...there is only one !). So ...
>>>
>>> Marc MILLAS
>>> Senior Architect
>>> +33607850334
>>> www.mokadb.com
>>>
>>>
>>>
>>> On Thu, May 18, 2023 at 9:30 PM Adrian Klaver 
>>> wrote:
>>>
 On 5/18/23 11:56, Ron wrote:
 > On 5/18/23 12:54, Rob Sargent wrote:
 >> On 5/18/23 11:49, Ron wrote:

 > We need to keep costs down, too.
 >
 > Oracle (I think) does it at the DB level, and so does SQL Server.
 Upper
 > Management hears us say "sorry, no can do" and wonders what bunch of
 > amateurs are developing PostgreSQL.

 Looks like you will be migrating to Oracle or SQL Server.

 Good luck on keeping costs down.

 >
 > --
 > Born in Arizona, moved to Babylonia.

 --
 Adrian Klaver
 adrian.kla...@aklaver.com

Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?

[Ron]

db... schema... cross-db terms get confusing when different systems use the 
same word to mean different things.


On 5/21/23 06:13, Marc Millas wrote:
Oracle have One (1) DB per instance (in Oracle its not named a cluster 
as...there is only one !). So ...


Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com 



On Thu, May 18, 2023 at 9:30 PM Adrian Klaver  
wrote:


On 5/18/23 11:56, Ron wrote:
> On 5/18/23 12:54, Rob Sargent wrote:
>> On 5/18/23 11:49, Ron wrote:

> We need to keep costs down, too.
>
> Oracle (I think) does it at the DB level, and so does SQL Server. Upper
> Management hears us say "sorry, no can do" and wonders what bunch of
> amateurs are developing PostgreSQL.

Looks like you will be migrating to Oracle or SQL Server.

Good luck on keeping costs down.

>
> --
> Born in Arizona, moved to Babylonia.

-- 
Adrian Klaver

adrian.kla...@aklaver.com





--
Born in Arizona, moved to Babylonia.

Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?

[Thomas Kellerer]

Marc Millas schrieb am 21.05.2023 um 13:13:

Oracle have One (1) DB per instance (in Oracle its not named a cluster 
as...there is only one !). So ...


Oracle can have multiple (pluggable) databases per instance since Oracle 12

Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?

[Marc Millas]

?? the sqlite thing ??

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com



On Sun, May 21, 2023 at 7:15 PM Theodore M Rolle, Jr. 
wrote:

> What about sqlcipher?
>
> On Sun, May 21, 2023, 07:16 Marc Millas  wrote:
>
>> Oracle have One (1) DB per instance (in Oracle its not named a cluster
>> as...there is only one !). So ...
>>
>> Marc MILLAS
>> Senior Architect
>> +33607850334
>> www.mokadb.com
>>
>>
>>
>> On Thu, May 18, 2023 at 9:30 PM Adrian Klaver 
>> wrote:
>>
>>> On 5/18/23 11:56, Ron wrote:
>>> > On 5/18/23 12:54, Rob Sargent wrote:
>>> >> On 5/18/23 11:49, Ron wrote:
>>>
>>> > We need to keep costs down, too.
>>> >
>>> > Oracle (I think) does it at the DB level, and so does SQL Server.
>>> Upper
>>> > Management hears us say "sorry, no can do" and wonders what bunch of
>>> > amateurs are developing PostgreSQL.
>>>
>>> Looks like you will be migrating to Oracle or SQL Server.
>>>
>>> Good luck on keeping costs down.
>>>
>>> >
>>> > --
>>> > Born in Arizona, moved to Babylonia.
>>>
>>> --
>>> Adrian Klaver
>>> adrian.kla...@aklaver.com
>>>
>>>
>>>
>>>

Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?

[Theodore M Rolle, Jr.]

What about sqlcipher?

On Sun, May 21, 2023, 07:16 Marc Millas  wrote:

> Oracle have One (1) DB per instance (in Oracle its not named a cluster
> as...there is only one !). So ...
>
> Marc MILLAS
> Senior Architect
> +33607850334
> www.mokadb.com
>
>
>
> On Thu, May 18, 2023 at 9:30 PM Adrian Klaver 
> wrote:
>
>> On 5/18/23 11:56, Ron wrote:
>> > On 5/18/23 12:54, Rob Sargent wrote:
>> >> On 5/18/23 11:49, Ron wrote:
>>
>> > We need to keep costs down, too.
>> >
>> > Oracle (I think) does it at the DB level, and so does SQL Server. Upper
>> > Management hears us say "sorry, no can do" and wonders what bunch of
>> > amateurs are developing PostgreSQL.
>>
>> Looks like you will be migrating to Oracle or SQL Server.
>>
>> Good luck on keeping costs down.
>>
>> >
>> > --
>> > Born in Arizona, moved to Babylonia.
>>
>> --
>> Adrian Klaver
>> adrian.kla...@aklaver.com
>>
>>
>>
>>

Re: Trying to understand a failed upgrade in AWS RDS

[Mike Lissner]

> As far as I know it's impossible to reliably pg_upgrade a node that has
> subscriptions and eventually resume logical replication.
>

Should this go in the documentation somewhere? Maybe in the pg_upgrade
notes? I still don't understand the mechanism. You also say that:


> It's possible to make it work with some efforts in some basic
> configurations and / or if no changes happen on the publications
>

But that kind of surprises me too, actually, because it seemed like
pg_upgrade wiped out the LSN locations of the subcriber, making it start
all over.

Upgrading a subscriber seems like something that could/should work, so it
should be documented if pg_upgrade is incompatible with maintaining a
subscription, shouldn't it?

Re: Profiling a function call

[Pavel Stehule]

ne 21. 5. 2023 v 13:30 odesílatel Jan Wieck  napsal:

> On 5/20/23 00:36, Tiffany Thang wrote:
> > Hi,
> > I have a function that has been executing for a long time and not
> > returning any results. Wait event=NULL so it seems like it is still
> > executing and not waiting on any specific resources. Is there a way to
> > profile the function call to get an idea of what it is currently
> > executing within the function? All I could find in pg_stat_activity is
> > the function is running. I want to know what query/transaction within
> > the function is running. Is there a way to obtain that information?
>
> This may give you some idea. I haven't touched or used it in many years,
> but it might get you started:
>
> https://github.com/wieck/plbacktrace


plpgsql_check has integrated tracer

https://github.com/okbob/plpgsql_check#tracer

Regards

Pavel


>
>
>
> Best Regards, Jan
>
> >
> > PostgreSQL 15.2 on Linux.
> >
> > Thanks.
> >
> > Tiff
>
>
>
>

Re: Profiling a function call

[Jan Wieck]

On 5/20/23 00:36, Tiffany Thang wrote:

Hi,
I have a function that has been executing for a long time and not 
returning any results. Wait event=NULL so it seems like it is still 
executing and not waiting on any specific resources. Is there a way to 
profile the function call to get an idea of what it is currently 
executing within the function? All I could find in pg_stat_activity is 
the function is running. I want to know what query/transaction within 
the function is running. Is there a way to obtain that information?


This may give you some idea. I haven't touched or used it in many years, 
but it might get you started:


https://github.com/wieck/plbacktrace


Best Regards, Jan



PostgreSQL 15.2 on Linux.

Thanks.

Tiff

Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?

[Marc Millas]

Oracle have One (1) DB per instance (in Oracle its not named a cluster
as...there is only one !). So ...

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com



On Thu, May 18, 2023 at 9:30 PM Adrian Klaver 
wrote:

> On 5/18/23 11:56, Ron wrote:
> > On 5/18/23 12:54, Rob Sargent wrote:
> >> On 5/18/23 11:49, Ron wrote:
>
> > We need to keep costs down, too.
> >
> > Oracle (I think) does it at the DB level, and so does SQL Server. Upper
> > Management hears us say "sorry, no can do" and wonders what bunch of
> > amateurs are developing PostgreSQL.
>
> Looks like you will be migrating to Oracle or SQL Server.
>
> Good luck on keeping costs down.
>
> >
> > --
> > Born in Arizona, moved to Babylonia.
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>
>
>
>