On 8/7/25 18:20, Charles Qi wrote:
As I stated before, when the BEFORE ROW UPDATE trigger is absent, even
if we update the same row in multiple subtransactions inside one top
transaction, no multixact will be created.
Check the attached no_multi.sql for example.
Yeah, I saw that in your previou
As I stated before, when the BEFORE ROW UPDATE trigger is absent, even
if we update the same row in multiple subtransactions inside one top
transaction, no multixact will be created.
Check the attached no_multi.sql for example.
Let me clarify the question, when the BEFORE ROW UPDATE trigger is pre
On Fri, Aug 8, 2025 at 2:26 PM Greg Sabino Mullane
wrote:
> There is a scenario: the current timeline of the PostgreSQL primary node
>> is 1, and the latest WAL file is 100. The standby node has also received up
>> to WAL file 100. However, the latest WAL file archived is only file 80. If
>> the
>
> There is a scenario: the current timeline of the PostgreSQL primary node
> is 1, and the latest WAL file is 100. The standby node has also received up
> to WAL file 100. However, the latest WAL file archived is only file 80. If
> the primary node crashes at this point and the standby is promote
On 8/7/25 22:50, px shi wrote:
Thank you for your reply.
The archived files can be used for PITR (Point-In-Time Recovery),
allowing recovery to any point between WAL 80 and 100 on timeline 1.
Additionally, if there's a backup taken during timeline 1 and a
switchover to a new primary has occurre
I managed to solve it now, it was just a connection error in one of the components of my Delphi, I just deleted it and put it back in 😭but thank you all very much for your help
On ago 7 2025, at 1:03 pm, Adrian Klaver wrote:
On 8/
On Fri, Aug 8, 2025 at 1:33 AM Tom Lane wrote:
> Christoph Moench-Tegeder writes:
> > ## Dominique Devienne (ddevie...@gmail.com):
> >> dd_v185=> call "Epos-DBA".db_grant_connect_to(grantee_role => 'dd_joe');
> >> ERROR: procedure Epos-DBA.db_grant_connect_to(grantee_role =>
> >> unknown) does n
