Standby server does not start with base backup
| От | Sanjay Rao |
|---|---|
| Тема | Standby server does not start with base backup |
| Дата | |
| Msg-id | 4DFC687A.8080703@noida.interrasystems.com обсуждение исходный текст |
| Ответ на | Re: Encryption For Specific Column- Where to store the key (Manuel Gysin <manuel.gysin@quantum-bytes.com>) |
| Ответы |
Re: Standby server does not start with base backup
|
| Список | pgsql-general |
Hi, I am running a test setup for verifying the warm standby feature in Postgres 9.0 release. Both my Master (Win 7 Professional, 64 bit) & Standby (Win 7 Professional, 64 bit) machines are having Postgres 9.0 (postgresql-9.0.4-1-windows) installed & both are in our LAN environment. After taking a base backup of the master database using pg_start_backup() & copy of the data folder to Standby machine followed by pg_stop_backup() in Master, the Standby server is started. The Standby server logs show the following error and the standby Postgres server shuts down. After this it never starts 2011-06-18 13:56:32 IST LOG: entering standby mode 2011-06-18 13:56:32 IST LOG: streaming replication successfully connected to primary 2011-06-18 13:56:32 IST FATAL: the database system is starting up 2011-06-18 13:56:33 IST LOG: redo starts at 0/3000020 2011-06-18 13:56:33 IST FATAL: the database system is starting up 2011-06-18 13:56:34 IST LOG: consistent recovery state reached at 0/5000000 2011-06-18 13:56:34 IST FATAL: the database system is starting up 2011-06-18 13:56:35 IST FATAL: the database system is starting up 2011-06-18 13:56:36 IST FATAL: the database system is starting up 2011-06-18 13:56:37 IST FATAL: the database system is starting up 2011-06-18 13:56:38 IST FATAL: the database system is starting up 2011-06-18 13:56:39 IST FATAL: the database system is starting up . . . .and same message continues.. I have attached the configuration files of standby server. Please help me if anybody have any such experience or know the exact cause of the issue. Regards, Sanjay
Вложения
В списке pgsql-general по дате отправления: