HotStandby vs. flatfile updates
От | Bernd Helmle |
---|---|
Тема | HotStandby vs. flatfile updates |
Дата | |
Msg-id | FA792E2899B619C3B5BF80FE@teje обсуждение исходный текст |
Ответы |
Re: HotStandby vs. flatfile updates
|
Список | pgsql-hackers |
I'm currently facing with a strange behavior during HotStandby Testing. That's what i'm actually doing: MASTER: CREATE DATABASE foo; <do something in there, e.g. restoring a dump> <wait until xlog segments get consumed by standby node (using archive_timeout)> STANDBY: postgres=# SELECT oid, datname FROM pg_database; oid | datname -------+----------- 1 | template111561 | template011562 | postgres16384 | test16390 | test217872 | bernd17873 | foo $ psql foo DEBUG: forked new backend, pid=19967 socket=7 FATAL: database "foo" does not exist $ cat standby/global/pg_database "template1" 1 1663 666 "template0" 11561 1663 666 "postgres" 11562 1663 666 "test" 16384 1663 666 "test2" 16390 1663 666 "bernd" 17872 1663 666 Obviously, the pg_database file wasn't updated. I've traced through the recovery process a little bit and i see BuildFlatFile() called during xact_redo_commit(), however, write_database_file() doesn't write out the new database records. Funny thing: the same happened to the database "bernd" before, so it seems to me the new database record is not visible to write_database_file() during redo? -- Thanks Bernd
В списке pgsql-hackers по дате отправления: