Re: Is there a way to change email for subscription ?

thanks for the clarification. Regards On Thu, 5 Sep 2024 at 11:15, Abdul Qoyyuum wrote: > I believe that's the only way to do it. > > On Thu, Sep 5, 2024 at 12:09 PM Muhammad Ikram wrote: > >> >> Hi, >> >> I want to change email for my PostgreSQL community subscriptions. Is >> there a way to

Is there a way to change email for subscription ?

Hi, I want to change email for my PostgreSQL community subscriptions. Is there a way to do it without unsubscribing and then subscribing to a new email ? -- Regards, Muhammad Ikram

Re: Please remove p...@mipta.com from the List

On 9/4/24 18:29, Peter L Martin wrote: Please remove p...@mipta.com from the List Follow instructions here: https://lists.postgresql.org/unsubscribe/ -- Adrian Klaver adrian.kla...@aklaver.com

Remove from distribution list

Please remove p...@mipta.com from the distribution list thank you Peter L Martin MIPTA ABN 74 843 345 087 p...@mipta.com Mobile Au: +61 (0)437 414 689 Todays problems will not be solved, if we think the same, as when we created them! - Albert Einstein Informa

Please remove p...@mipta.com from the List

Please remove p...@mipta.com from the List Thank you Peter L Martin MIPTA ABN 74 843 345 087 p...@mipta.com Mobile Au: +61 (0)437 414 689 Todays problems will not be solved, if we think the same, as when we created them! - Albert Einstein Information in this

Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16

On 9/4/24 10:46, Sam Son wrote: Hi Adrian, Thanks for your suggestions. I will try your modifications and do benchmarking. I got to thinking and realized I missed an important part about separating the schema and data restores using the -s and -a arguments. This is best explained here: ht

Re: question on audit columns

> > On 9/4/24 06:17, Khan Muhammad Usman wrote: > > Yes this would be the better approach. > > 1) Except the overhead is now shifted to the application, which may or > not be better. You are also moving the audit responsibility to the > application and the application maintainers and making it appl

Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16

Hi Adrian, Thanks for your suggestions. I will try your modifications and do benchmarking. Thanks, Samson G On Wed, Sep 4, 2024 at 8:34 PM Adrian Klaver wrote: > On 9/4/24 03:48, Sam Son wrote: > > Hi Adrian, Muhammad, > > > > Thanks for the quick response. > > > > For new I cannot do changes

Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16

On 9/4/24 03:48, Sam Son wrote: Hi Adrian, Muhammad, Thanks for the quick response. For new I cannot do changes in old version DB, since it is deployed remotely and i dont have any access. And it has to be done from multiple servers. As a work around I tried two solutions. Both of which d

Re: question on audit columns

On 9/4/24 06:17, Khan Muhammad Usman wrote: Yes this would be the better approach. 1) Except the overhead is now shifted to the application, which may or not be better. You are also moving the audit responsibility to the application and the application maintainers and making it application s

Re: question on audit columns

On Wed, Sep 4, 2024 at 9:10 AM yudhi s wrote: > > On Wed, Sep 4, 2024 at 6:29 PM Muhammad Usman Khan > wrote: > >> Hi, >> >> In your scenario, triggers can add some overhead since they require extra >> processing after each update operation. Considering the size of your table >> and the high tra

Re: question on audit columns

Yes this would be the better approach. Sent from Outlook for Android From: yudhi s Sent: Wednesday, September 4, 2024 6:10:04 PM To: Muhammad Usman Khan Cc: pgsql-general Subject: Re: question on audit columns On Wed, Sep 4, 2024 at 6:2

Re: question on audit columns

On Wed, Sep 4, 2024 at 6:29 PM Muhammad Usman Khan wrote: > Hi, > > In your scenario, triggers can add some overhead since they require extra > processing after each update operation. Considering the size of your table > and the high transaction volume, you need to observe that this might > signi

Re: question on audit columns

Hi, In your scenario, triggers can add some overhead since they require extra processing after each update operation. Considering the size of your table and the high transaction volume, you need to observe that this might significantly affect performance. On Wed, 4 Sept 2024 at 17:50, yudhi s

question on audit columns

Hello, In postgres database , we have all the tables with audit columns like created_by_user, created_timestamp,updated_by_user, updated_timestamp. So we have these fields that were supposed to be populated by the time at which the insert/update operation happened on the database but not at the app

Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16

Hi Adrian, Muhammad, Thanks for the quick response. For new I cannot do changes in old version DB, since it is deployed remotely and i dont have any access. And it has to be done from multiple servers. As a work around I tried two solutions. *Solution 1:* After downloading and extracting the d

Re: libpq15 with postgres server16 and scram-sha-256

On Wed, 2024-09-04 at 11:54 +0100, MM wrote: > is it possible to connect with PGConnectdb version 15 to a server that has in > METHOD in pg_hba.conf   "scram-sha-256" > or do I need version libpq 16 ? You can use "scram-sha-256" authentication from v10 on. Note that it only works if the database

libpq15 with postgres server16 and scram-sha-256

Hello is it possible to connect with PGConnectdb version 15 to a server that has in METHOD in pg_hba.conf "scram-sha-256" or do I need version libpq 16 ? If so, being constrained to remain at 15 libpq for now, is md5 allowed? Rds,