Re: Operation log for major operations

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Operation log for major operations
Date: 2022-11-23 09:00:21
Message-ID: 20221123090021.ba5johlgwwdx2nzm@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2022-Nov-21, Dmitry Koval wrote:

> Concepts.
> ---------
> * operation log is placed in the file 'global/pg_control', starting from
> position 4097 (log size is 4kB);

I think storing this in pg_control is a bad idea. That file is
extremely critical and if you break it, you're pretty much SOL on
recovering your data. I suggest that this should use a separate file.

--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
"All rings of power are equal,
But some rings of power are more equal than others."
(George Orwell's The Lord of the Rings)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2022-11-23 09:02:04 Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt"
Previous Message David Rowley 2022-11-23 08:56:15 Re: Non-decimal integer literals