Tue Oct 24 02:48:43 PDT 2006
- Previous message: [Slony1-general] Hello!! Please its very imporatnt
- Next message: [Slony1-general] RPM for version 1.2.0 of slony?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Replace _slonrep by your own cluster name. John db=# \dt _slonrep.sl_* List of relations Schema | Name | Type | Owner ----------+----------------+-------+---------- _slonrep | sl_config_lock | table | postgres _slonrep | sl_confirm | table | postgres _slonrep | sl_event | table | postgres _slonrep | sl_listen | table | postgres _slonrep | sl_log_1 | table | postgres _slonrep | sl_log_2 | table | postgres _slonrep | sl_node | table | postgres _slonrep | sl_nodelock | table | postgres _slonrep | sl_path | table | postgres _slonrep | sl_seqlog | table | postgres _slonrep | sl_sequence | table | postgres _slonrep | sl_set | table | postgres _slonrep | sl_setsync | table | postgres _slonrep | sl_subscribe | table | postgres _slonrep | sl_table | table | postgres _slonrep | sl_trigger | table | postgres (16 rows) db=# \dv _slonrep.sl_* List of relations Schema | Name | Type | Owner ----------+----------------+-------+---------- _slonrep | sl_seqlastvalue | view | postgres _slonrep | sl_status | view | postgres (2 rows) db=# select st_origin,st_received,st_lag_num_events,st_lag_time from _slonrep.sl_status; st_origin | st_received | st_lag_num_events | st_lag_time -----------+-------------+-------------------+----------------- 1 | 2 | 0 | 00:00:08.250889 (1 row) tomekbu wrote: > Hello!! > > I have been using slony for several days. Its very usfull tool. Now I > have two questions: > 1. How can view, search the table that slony hold all its paths, nodes, > sets etc?? Can I look in it with postgreSQL? > 2. Is there any request in slony that will tell me when slave database > has been totally replicated. I mean process of replication finished with > success and both master database and slave database are the same??? > > Please its very important for me, so if somebody has any idea ill be > very greatefull!!! > > Best Regards, > Tomasz Burda > _______________________________________________ > Slony1-general mailing list > Slony1-general at gborg.postgresql.org > http://gborg.postgresql.org/mailman/listinfo/slony1-general
- Previous message: [Slony1-general] Hello!! Please its very imporatnt
- Next message: [Slony1-general] RPM for version 1.2.0 of slony?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list