Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display

От

Euler Taveira

Тема

Дата

11 ноября 2021 г. в 15:46:47

Msg-id

6e1625c2-ad82-4dad-8ccf-01d8a7dbb0d3@www.fastmail.com

обсуждение

Ответ на

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display (Bharath Rupireddy)

Список

pgsql-hackers

Дерево обсуждения

add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> 10 ноября 2021 г. в 17:38:51

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display "Euler Taveira" <euler@eulerto.com> 10 ноября 2021 г. в 20:09:43

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> 11 ноября 2021 г. в 05:53:09

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display "Bossart, Nathan" <bossartn@amazon.com> 10 ноября 2021 г. в 18:31:20

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Alvaro Herrera <alvherre@alvh.no-ip.org> 11 ноября 2021 г. в 12:37:41

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display "Bossart, Nathan" <bossartn@amazon.com> 11 ноября 2021 г. в 15:11:49

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> 13 ноября 2021 г. в 13:59:36

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Alvaro Herrera <alvherre@alvh.no-ip.org> 13 ноября 2021 г. в 15:34:37

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> 14 ноября 2021 г. в 12:17:41

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display "Bossart, Nathan" <bossartn@amazon.com> 15 ноября 2021 г. в 22:36:09

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Michael Paquier <michael@paquier.xyz> 16 ноября 2021 г. в 03:13:51

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display "Bossart, Nathan" <bossartn@amazon.com> 16 ноября 2021 г. в 16:01:54

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Alvaro Herrera <alvherre@alvh.no-ip.org> 16 ноября 2021 г. в 16:26:49

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Michael Paquier <michael@paquier.xyz> 17 ноября 2021 г. в 02:31:16

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> 7 декабря 2021 г. в 12:58:24

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Michael Paquier <michael@paquier.xyz> 8 декабря 2021 г. в 04:35:48

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> 8 декабря 2021 г. в 05:17:57

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Michael Paquier <michael@paquier.xyz> 8 декабря 2021 г. в 07:21:55

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Michael Paquier <michael@paquier.xyz> 8 декабря 2021 г. в 08:38:14

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Michael Paquier <michael@paquier.xyz> 9 декабря 2021 г. в 02:26:38

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> 9 декабря 2021 г. в 05:58:41

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Alvaro Herrera <alvherre@alvh.no-ip.org> 9 декабря 2021 г. в 12:30:34

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Alvaro Herrera <alvherre@alvh.no-ip.org> 9 декабря 2021 г. в 15:58:21

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> 12 декабря 2021 г. в 12:38:05

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Ashutosh Sharma <ashu.coek88@gmail.com> 12 ноября 2021 г. в 15:40:48

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display "Bossart, Nathan" <bossartn@amazon.com> 11 ноября 2021 г. в 15:18:16

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display Bruce Momjian <bruce@momjian.us> 11 ноября 2021 г. в 17:46:38

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display "Euler Taveira" <euler@eulerto.com> 11 ноября 2021 г. в 15:46:47

On Thu, Nov 11, 2021, at 2:50 AM, Bharath Rupireddy wrote:

But for the snprintf(activitymsg, sizeof(activitymsg), "archiving %s",
xlog); we have elog(DEBUG1, "archived write-ahead log file \"%s\"",
xlog); after the archiving command. It is also good to have a similar
debug message before archive command execution, we can get to know
whether archive command is executed or not, if yes how much time did
it take etc.?

If you are only interested in how much time it took to archive a WAL file, you

don't need 2 messages (before and after); one message is sufficient. If you

calculate the difference and then print it as part of the existent message.

Calculate the difference iif the log level is at least DEBUG1 (same as the log

message).

Messages related to system() e.g. archive and recovery, you could measure the

execution time in your own script/program.

I like Alvaro's idea of implementing a ring buffer for this kind of activity.

This implementation could be applied to checkpoints, archiving, recovery,

replication, base backup, WAL usage, connections and others.

Euler Taveira

EDB https://www.enterprisedb.com/