Make basebackup use low level API and rsync

From: wd <wd(at)wdicc(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Make basebackup use low level API and rsync
Date: 2014-04-22 04:28:42
Message-ID: CABexzmg2KE7J+J8gZUP4+x9ygP_ENw0nR+d2BoMsLOwhxUOtsg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

I'v try to make a base backup use pg_start_backup, pg_stop_backup and
rsync, but failed.

After run select pg_start_backup('label') on db server, I run rsync on
backup server, and got some errors like 'file has vanished: xxxx', think
this should be ok since it's documented in the manual. Then run select
pg_stop_backup() to end the backup.

But when I try to use this backup to restore to a specific time on backup
server, got errors bellow:

[ 2014-04-11 20:50:47.610 CST]LOG: restored log file
"00000001000005FF000000F8" from archive
[ 2014-04-11 20:50:56.698 CST]LOG: restored log file
"00000001000005FF000000F9" from archive
[ 2014-04-11 20:51:05.552 CST]LOG: restored log file
"00000001000005FF000000FA" from archive
[ 2014-04-11 20:51:16.171 CST]LOG: restored log file
"00000001000005FF000000FB" from archive
[ 2014-04-11 20:51:20.785 CST]WARNING: specified item offset is too
large
[ 2014-04-11 20:51:20.785 CST]CONTEXT: xlog redo insert: rel
1663/1/12633; tid 1/15
[ 2014-04-11 20:51:20.785 CST]PANIC: btree_insert_redo: failed to add
item
[ 2014-04-11 20:51:20.785 CST]CONTEXT: xlog redo insert: rel
1663/1/12633; tid 1/15
[ 2014-04-11 20:51:20.903 CST]LOG: startup process (PID 4758) was
terminated by signal 6: Aborted
[ 2014-04-11 20:51:20.903 CST]LOG: terminating any other active server
processes

We do this base backup everyday, and the error occur sometimes, not always
happen. I think it's must something wrong in our operations, anyone know
why this happen? May be we should not use rsync or there is something
impotent we missed ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2014-04-22 05:58:50 Re: Make basebackup use low level API and rsync
Previous Message Ron Pasch 2014-04-21 12:08:34 Re: Could use some advice on search architecture