9.0 standby - could not open file global/XXXXX

Поиск
Список
Период
Сортировка
От Filip Rembiałkowski
Тема 9.0 standby - could not open file global/XXXXX
Дата
Msg-id CAP_rwwmG2aOjCEWdag5fEAYM=LX9_9LxJRYHc9MiStWZaqOz0w@mail.gmail.com
обсуждение исходный текст
Ответы Re: 9.0 standby - could not open file global/XXXXX  (Stephen Frost <sfrost@snowman.net>)
Re: 9.0 standby - could not open file global/XXXXX  (Andres Freund <andres@anarazel.de>)
Re: 9.0 standby - could not open file global/XXXXX  (Filip Rembiałkowski <filip.rembialkowski@gmail.com>)
Список pgsql-general
Hi.

There is a large (>5T) database on PostgreSQL 9.0.23.

I would like to setup new WAL-shipping standby.
https://www.postgresql.org/docs/9.0/warm-standby.html

On my way I find unexpected issues. Here's the story, in short:

1. WAL archiving to remote archive is setup & verified

2. base backup is transferred directly to new server using
pg_start_backup + rsync + pg_stop_backup.

3. recovery.conf is created

4. Server is started and consumes all the remaining WAL segments
accumulated in the archive - finishing with optimistic message LOG:
consistent recovery state reached at 9FC1/112BEE10.

5. When I go to postgres on the standby and try to connect system
"postgres" database psql: FATAL:  could not open file "global/11819":
No such file or directory

I guessed the OID refereds to the pg_authid, but other system tables
might be affected too.

What could be wrong here?

Thanks!


В списке pgsql-general по дате отправления:

Предыдущее
От: wambacher@posteo.de
Дата:
Сообщение: update table with suppress_redundant_updates_trigger()
Следующее
От: Ken Tanzer
Дата:
Сообщение: Re: Recommended way to enable data-checksums on Centos 7?