Hello, everybody. I solved the problem. The index has been corrupted after replication despite it was appeared as not corrupted. It was solved by recreating the index. Thank you for the help. -- Пожалуйста! Используйте кнопку "ответить всем". Не удаляйте историю переписки. Спасибо. С уважением, Timokhin 'maf' Maxim 30.06.2017, 17:33, "Timokhin Maxim" <ncx2@xxxxxxxxxx>: > Sure, here it is. > > pg_basebackup -h servername -R -P -D /data/upgrade/94 -U pgsql -v —xlog-method=stream —checkpoint=fast > > /usr/pgsql-9.5/bin/initdb -D /data/upgrade/95/ —encoding=utf8 —locale=ru_RU.utf8 —lc-collate=ru_RU.utf8 —lc-ctype=ru_RU.utf8 —lc-messages=en_US.utf8 > > Then updating: > /usr/pgsql-9.5/bin/pg_upgrade -b /usr/pgsql-9.4/bin/ -d /data/upgrade/94 -B /usr/pgsql-9.5/bin/ -D /data/upgrade/95 -k > > and so on to 9.6 > > after that server starts normally. > > -- > Timokhin 'maf' Maxim > > 30.06.2017, 16:07, "Adrian Klaver" <adrian.klaver@xxxxxxxxxxx>: >> On 06/30/2017 04:58 AM, Timokhin Maxim wrote: >>> BTW, we are moving using: >>> >>> pg_basebackup -h servername -R -P -D /data/upgrade/94 -U pgsql -v —xlog-method=stream —checkpoint=fast >> >> Going from 9.4 to 9.6 is a major version upgrade and you cannot use >> pg_basebackup for that. Besides I can't see how you even got the 9.6.3 >> server to start: >> >> /usr/local/pgsql94/bin/pg_basebackup -D /home/aklaver/pgback_test94 -U >> postgres -p 5412 -v --xlog-method=stream >> >> /usr/local/pgsql96/bin/pg_ctl -D /home/aklaver/pgback_test94/ start >> server starting >> FATAL: database files are incompatible with server >> DETAIL: The data directory was initialized by PostgreSQL version 9.4, >> which is not compatible with this version 9.6.3 >> >>> After that we are upping version to 9.6.3. >> >> Given the above how did you actually get 9.6.3 to start? >> >>> I've looked through the documentation https://postgrespro.ru/docs/postgrespro/9.6/app-pgbasebackup and didn't find details about how pg_basebackup works with b-tree indexes. >>> Is it possible that pg_basebackup just copies indexes as is and that is cause of corruption. Or it pass indexes as instruction that says "after upping db make indexes" ? >>> >>> Thank you. >>> >>> -- >>> Timokhin 'maf' Maxim >> >> -- >> Adrian Klaver >> adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
