On 2013-04-24 19:44:25 -0700, Sergey Konoplev wrote: > On Wed, Apr 24, 2013 at 5:05 PM, Adarsh Sharma <eddy.adarsh@xxxxxxxxx> wrote: > > I have a Postgresql 9.2 instance running on a CentOS6.3 box.Yesterday i > > setup a hot standby by using pgbasebackup. Today i got the below alert from > > standby box : > > > > [1] (from line 412,723) > > 2013-04-24 23:07:18 UTC [13445]: [6-1] user= db= host= PANIC: > > _bt_restore_page: cannot add item to page > > > > When i check, the replication is terminated due to slave DB shutdown. From > > the logs i can see below messages :- Does the global/14078 file exist on the primary? What exact commandline were you using to restore? Which exact version of postgres? > I am not sure that it is your situation but take a look at this thread: > > http://www.postgresql.org/message-id/CAL_0b1t=WuM6roO8dki=w8DhH8P8whhohbPjReymmQUrOcNT2A@xxxxxxxxxxxxxx > > There is a patch by Andres Freund in the end of the discussion. The issues don't look related. > Three > weeks have passed after I installed the patched version and it looks > like the patch fixed my issue. Oh, cool! Thanks for verifying. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
