Wed Aug 27 12:18:11 PDT 2008
- Previous message: [Slony1-general] Solution: table is an index corruption
- Next message: [Slony1-general] Simple replication taking eons to complete
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Yesterday afternoon I installed Slony 1.2.10 against Postgres 8.0 on a Gentoo box, and set up two pgbench databases with it, "pgbench_master" and "pgbench_slave". With the two "slon" processes running, I ran "pgbench -i" and "pgbench" from another host. As of right now, the data still isn't replicated: pgbench_master=# SELECT aid,bid,abalance FROM accounts ORDER BY abalance DESC LIMIT 10; aid | bid | abalance ---------+-----+---------- 1541195 | 16 | 938 1131104 | 12 | 929 230915 | 3 | 906 ... pgbench_slave=# SELECT aid,bid,abalance FROM accounts ORDER BY abalance DESC LIMIT 10; aid | bid | abalance -------+-----+---------- 29533 | 1 | 1747 23957 | 1 | 1704 99989 | 1 | 1624 ... The system is a single-CPU Pentium 4 2.8GHz with 1G of RAM, not running any other active applications. Is this sort of delay normal with Slony? If it's stuck, how do I unstick it? -- David L. Lambert Software Developer, Precision Motor Transport Group, LLC Work phone 517-349-3011 x215 Cell phone 586-873-8813
- Previous message: [Slony1-general] Solution: table is an index corruption
- Next message: [Slony1-general] Simple replication taking eons to complete
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list