'missing' data on replicate
| От | Alan Nilsson |
|---|---|
| Тема | 'missing' data on replicate |
| Дата | |
| Msg-id | 92FB745C-EADD-4ABF-A28D-C5A2CC977560@apple.com обсуждение исходный текст |
| Ответы |
Re: 'missing' data on replicate
|
| Список | pgsql-general |
I have 4 machines in a cluster: 1 master & 2 replicates (hot standby mode) on OSX, 1 replicate (hot standby mode) on Linux(centos6.5). All replicates were created with pg_basebackup (+ X option). I have a table that returns no results when queried by the primary key on the replicate running on Linux. The same queryreturns data on all other machines in the cluster. The data is there, if I query on anything other than the PK, I getthe results I expect. a) Is this a corrupt index? Something entirely different? b) How can I rebuild index on slave? Rebuilding on master did not fix. c) What are the possible ways of getting this way? I’ve never seen this before and I’m not really sure how to proceed. I can take the Linux machine offline and rebuild thewhole thing but I would rather know how this happened & fix it in place. We are in the process of migrating everythingto Linux and this box is a test bed. Before I commit everything to a new linux cluster I’ld like to understandwhat I am seeing. thanks alan
В списке pgsql-general по дате отправления: