Skip site navigation (1) Skip section navigation (2)

replication failure with GIN index

From: Rural Hunter <ruralhunter(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: replication failure with GIN index
Date: 2012-04-06 01:56:25
Message-ID: 4F7E4D49.1040106@gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
I'm trying to set up a standby server. Both the primary and standby 
servers are on latest version 9.1.3 on ubunt server 10.10. So far I 
tried to init the setup 2 times but both failed after the replication 
running for some time. what can I do to fix this? The log on the standby 
is shown below:

2012-04-06 02:31:01 CST [(at)] LOG:  restored log file 
"0000000200000E3C000000F1" from archive
2012-04-06 02:35:35 CST [(at)] LOG:  restored log file 
"0000000200000E3C000000F2" from archive
2012-04-06 02:36:19 CST [(at)] LOG:  restored log file 
"0000000200000E3C000000F3" from archive
2012-04-06 02:36:48 CST [(at)] LOG:  restored log file 
"0000000200000E3C000000F4" from archive
2012-04-06 02:37:24 CST [(at)] LOG:  restored log file 
"0000000200000E3C000000F5" from archive
2012-04-06 02:37:27 CST [(at)] PANIC:  GIN metapage disappeared
2012-04-06 02:37:27 CST [(at)] CONTEXT:  xlog redo Update metapage, node: 
37547844/16405/83896882 blkno: 4294967295
2012-04-06 02:37:28 CST [(at)] LOG:  startup process (PID 24912) was 
terminated by signal 6: Aborted
2012-04-06 02:37:28 CST [(at)] LOG:  terminating any other active server 
processes


Responses

pgsql-admin by date

Next:From: Simon RiggsDate: 2012-04-06 07:38:38
Subject: Re: replication failure with GIN index
Previous:From: Dave JohansenDate: 2012-04-05 18:27:44
Subject: libpqxx for x86 builds of RHEL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group