Обсуждение: pg_stat_replication_slots view
Hi,
While I was referring to the below blog, where it talks about the pg_stat_replication_slots view. I don't, however, see that in Postgres 13. I'm not sure whether there is something I am overlooking. Anyone who can help me out here?
postgres=> \d pg_stat_replication_slots
Did not find any relation named "pg_stat_replication_slots".
Did not find any relation named "pg_stat_replication_slots".
Regards,
Satalabha
Checked in postgresql 14 as well. I don't see it there as well.
version
-------------------------------------------------------------------------------------------------
PostgreSQL 14.3 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit
(1 row)
-------------------------------------------------------------------------------------------------
PostgreSQL 14.3 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit
(1 row)
postgres=> \d pg_stat_replication_slot
Did not find any relation named "pg_stat_replication_slot".
Did not find any relation named "pg_stat_replication_slot".
Regards,
Satalabha
On Sun, 8 Jan 2023 at 20:08, Satalabaha Postgres <satalabaha.postgres@gmail.com> wrote:
Hi,While I was referring to the below blog, where it talks about the pg_stat_replication_slots view. I don't, however, see that in Postgres 13. I'm not sure whether there is something I am overlooking. Anyone who can help me out here?postgres=> \d pg_stat_replication_slots
Did not find any relation named "pg_stat_replication_slots".Regards,Satalabha
> On Jan 8, 2023, at 7:49 AM, Satalabaha Postgres <satalabaha.postgres@gmail.com> wrote: > > pg_stat_replication_slot Introduced in 14, which is why you didn't find it in 13. You didn't find it in 14 because you misspelled it (it's slots, not slot).
My bad. Thanks a lot Sabra and Scott.
Regards,
Satalabha
On Sun, 8 Jan 2023 at 20:44, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
> On Jan 8, 2023, at 7:49 AM, Satalabaha Postgres <satalabaha.postgres@gmail.com> wrote:
>
> pg_stat_replication_slot
Introduced in 14, which is why you didn't find it in 13.
You didn't find it in 14 because you misspelled it (it's slots, not slot).
When in doubt, check the current docs and work backwards.
On 1/8/23 09:27, Satalabaha Postgres wrote:
My bad. Thanks a lot Sabra and Scott.Regards,SatalabhaOn Sun, 8 Jan 2023 at 20:44, Scott Ribe <scott_ribe@elevated-dev.com> wrote:> On Jan 8, 2023, at 7:49 AM, Satalabaha Postgres <satalabaha.postgres@gmail.com> wrote:
>
> pg_stat_replication_slot
Introduced in 14, which is why you didn't find it in 13.
You didn't find it in 14 because you misspelled it (it's slots, not slot).
--
Born in Arizona, moved to Babylonia.
Born in Arizona, moved to Babylonia.