Re: Pause streaming replication

2021-11-10 Thread Laurenz Albe
On Wed, 2021-11-10 at 20:36 -0500, Rita wrote: > On Wed, Nov 10, 2021 at 7:24 PM Ben Chobot wrote: > >Rita wrote on 11/10/21 1:25 PM: > > > Hello. > > > > > > I am testing alerting on my primary and standby setup. I have async > > > replication working but I would like to temporarily pause it so

Re: Pause streaming replication

2021-11-10 Thread Michael Paquier
On Wed, Nov 10, 2021 at 08:36:45PM -0500, Rita wrote: > Yes, I have read the manual and seen this. It pauses the replication > (select pg_is_wal_replay_paused()). But on the primary, when I look at > pg_stat_replication, it still says 'streaming' in the state column. My > question was how do I get

Re: Pause streaming replication

2021-11-10 Thread Ben Chobot
Rita wrote on 11/10/21 5:36 PM: Yes, I have read the manual and seen this. It pauses the replication (select pg_is_wal_replay_paused()). But on the primary, when I look at pg_stat_replication, it still says 'streaming' in the state column. My question was how do I get it from 'streaming'  to an

Re: Pause streaming replication

2021-11-10 Thread Rita
Yes, I have read the manual and seen this. It pauses the replication (select pg_is_wal_replay_paused()). But on the primary, when I look at pg_stat_replication, it still says 'streaming' in the state column. My question was how do I get it from 'streaming' to anything else? ( https://www.postgres

Re: Pause streaming replication

2021-11-10 Thread Ben Chobot
Rita wrote on 11/10/21 1:25 PM: Hello. I am testing alerting on my primary and standby setup. I have async replication working but I would like to temporarily pause it so the value of 'state' isn't streaming. (select * from pg_stat_replication). How can I do that? By reading the fine manua

Pause streaming replication

2021-11-10 Thread Rita
Hello. I am testing alerting on my primary and standby setup. I have async replication working but I would like to temporarily pause it so the value of 'state' isn't streaming. (select * from pg_stat_replication). How can I do that? -- --- Get your facts first, then you can distort them as you

Re: E.1.2. Migration to Version 14

2021-11-10 Thread Дмитрий Иванов
Хорошо спасибо! This does not give an understanding of the need to work with all the functions (Table 9.52) of arrays or specified in the release. I am working on version 12 of the main kernel. I didn’t see what I’ll get, other than being up-to-date when upgrading to version 14. I faced performance

Re: Logical Replication - Type messages?

2021-11-10 Thread Tom Lane
Stefen Hillman writes: > Currently, I process Relation messages to get most of the information I > need to work with Inserts, Updates, and Deletes. However, for type > information I'm currently using a SQL query to get the column type > information. I wanted to use the Type messages, but I never s

Re: E.1.2. Migration to Version 14

2021-11-10 Thread Bruce Momjian
On Wed, Nov 10, 2021 at 12:30:37PM +0500, Дмитрий Иванов wrote: > Hello! > E.1.2 Migration to Version 14 >  array_append(), array_prepend(), array_cat(), array_position(),  > array_positions(), array_remove(), array_replace(), and width_bucket() > > Is this a complete list of functions? Or you nee

Re: Understanding the differences between Temporal tables, CDC and Time Series.

2021-11-10 Thread SQL Padawan
Hi Peter, and thanks for answering. > > I'm unclear as to the "philosophical" distinctions here and would be > > grateful if anybody could explain the diffence(s) between them? > A time series database contains data records containing a time stamp > A temporal database contains records that