| Aaron Randall 2006-01-19, 9:24 am |
| Thanks. I have been looking at the _cluster.sl_status table, and it's
been really useful. The only problem I've got now is I would like to be
able to do some calculations with the st_lag_time field in
_my_cluster.sl_status table. As it is stored as an Interval, I would
really like it in just one format (e.g. seconds) so I could use it as an
integer. At the moment it looks something like this...
ipt=# select st_lag_time from _my_cluster.sl_status;
st_lag_time
-----------------
00:00:02.114107
(1 row)
I have looked into converting Interval Types, but have been told that
this conversion will no longer be supported by Postgres.
Any ideas?
Regards,
Aaron
Christopher Browne wrote:
> Aaron Randall <aaron.randall- LJ+G6BnwIY2akBO8gow8
eQ@public.gmane.org> writes:
>
>
> Well, you can get some implicit "all is running well" if you run
> select * from _cluster.sl_status;
>
> If it shows all the nodes you expect, and shows that they are only an
> event or two behind, then replication should be functioning well.
>
> That's about the best metric I can think of without looking at the
> logs.
>
> You could also run the script test_slony_state.pl (or the DBI
> version); that checks a number of things about how things are running.
>
|