How to check stream replication latest history status

2022-11-13 Thread
Hi All I set up Postgres 11 stream replication env.Use keepalived to control VIP and a script to check Postgres status. Usually. I could check the stream replication status by this view "pg_stat_replcation" on primary server. Check this view "pg_stat_wal_receiver" on standby

Re: About psql \dt unable display same name table which have different schema

2022-05-24 Thread
Hi Tom. Thanks for your explanation. I got it. I really appreciate it. Jack Xu. Tom Lane 于2022年5月25日周三 00:16写道: > =?UTF-8?B?5b6Q5b+X5a6H5b6Q?= writes: > > I don't know why this problem exist. Why unable display both table " > > public.test10 、 new. test10 " > > That's behaving as designe

About psql \dt unable display same name table which have different schema

2022-05-24 Thread
Hello All I experience a problem. The psql \dt command unable display same name table which have different schema. The table new. test10 unable display. Owing to the public.test10 exist. The pg_type_is_visible display "F" I don't know why this problem exist. Why unable display bot