Checkpoint Err on Startup of Rsynced System
От | Jim Longwill |
---|---|
Тема | Checkpoint Err on Startup of Rsynced System |
Дата | |
Msg-id | 574DC62A.2010908@psmfc.org обсуждение исходный текст |
Ответы |
Re: Checkpoint Err on Startup of Rsynced System
Re: Checkpoint Err on Startup of Rsynced System Re: Checkpoint Err on Startup of Rsynced System Re: Checkpoint Err on Startup of Rsynced System |
Список | pgsql-general |
I am trying to setup a 2nd, identical, db server (M2) for development and I've run into a problem with starting up the 2nd Postgres installation. Here's what I've done: 1) did a 'clone' of 1st (production) machine M1 (so both machines on Cent OS 7.2) 2) setup an rsync operation, did a complete 'rsync' from M1 to M2 3) did a final 'CHECKPOINT' command on M1 postgres 4) shutdown postgres on M1 with 'pg_ctl stop' 5) did final 'rsync' operation (then restarted postgres on M1 with 'pg_ctl start') 6) tried to startup postgres on M2 It won't start, & in the log file gives the error message: ... < 2016-05-31 09:02:52.337 PDT >LOG: invalid primary checkpoint record < 2016-05-31 09:02:52.337 PDT >LOG: invalid secondary checkpoint record < 2016-05-31 09:02:52.337 PDT >PANIC: could not locate a valid checkpoint record < 2016-05-31 09:02:53.184 PDT >LOG: startup process (PID 26680) was terminated by signal 6: Aborted < 2016-05-31 09:02:53.184 PDT >LOG: aborting startup due to startup process failure I've tried several times to do this but always get this result. So, do I need to do a new 'initdb..' operation on machine M2 + restore from M1 backups? Or is there another way to fix this? --o--o--o--o--o--o--o--o--o--o--o--o-- Jim Longwill PSMFC Regional Mark Processing Center JLongwill@psmfc.org --o--o--o--o--o--o--o--o--o--o--o--o--
В списке pgsql-general по дате отправления: