Since your column name has an Upper case character, you will have to use
double quotes to drop it. Try alter table statustypes drop column "Suspect";
Thanks,
Viral
On Wed, Dec 18, 2024 at 1:47 PM Rich Shepard
wrote:
> I'm not seeing why postgres won't drop a table's column:
>
> bustrac=# sele
wanted to also track the transfer/replay lag between the intermediate
server and the final standby. I narrowed down the problem with
pg_current_wal_lsn() procedure. Any idea on how to mitigate this? or any
alternative to the pg_current_wal_lsn() procedure that I can use to get
transfer lag?
Thanks,
,
pg_size_pretty(pg_wal_lsn_diff(pg_current_wal_lsn(), replay_lsn))
AS replay_lag
FROM pg_stat_replication;
I am now using zabbix to constantly monitor them and notify myself if
it breaches a certain threshold.
Thanks again!
Best,
Viral Shah
Nodal Exchange LLC
On Thu, Apr 15, 2021 at 8:10 AM
if
we have any metric that can calculate the amount (size) of WAL transfer
left between master and standby?
PS: We have ensured we have upgraded our firewalls for better speed
transfer.
Any help on how to figure out the slowness in the WAL transfer would
be much appreciated.
Thanks,
Viral Shah
