recreating point-in-time recovery when tables are in non-default tablespace

From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: recreating point-in-time recovery when tables are in non-default tablespace
Date: 2017-11-14 19:54:06
Message-ID: CADyzmyxx0UAcksUqeGRapKn4WZDQaT6JPcE-qy8n-cE5-ZyYFg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Good afternoon,

I have in the past been successful in creating a hot standby environment as
all my tables were in one cluster on one disk. The base backup (I used tar)
easily copied all tables and then the tar extract easily restored them on
our standby server. Since the last time this process was invoked I moved
about 14 of these tables to a non-default tablespace on another disk (to
alleviate space issues) Now the base backup does NOT pick up these tables
and I am getting errors on the restore side. Here is a copy the error:

: WARNING: page 36107 of relation
pg_tblspc/1057768125/PG_9.4_201409291/16469/2231796047 is uninitialized
Nov 14 13:46:20 ardbc01dr postgres[58399]: [572-2] @: CONTEXT: xlog redo
delete: index 1057768125/16469/2231796047; iblk 36107, heap
1663/16469/2202113342;
Nov 14 13:46:20 ardbc01dr postgres[58399]: [573-1] @: PANIC: WAL contains
references to invalid pages
Nov 14 13:46:20 ardbc01dr postgres[58399]: [573-2] @: CONTEXT: xlog redo
delete: index 1057768125/16469/2231796047; iblk 36107, heap
1663/16469/2202113342;
Nov 14 13:46:21 ardbc01dr postgres[58398]: [3-1] @: LOG: startup process
(PID 58399) was terminated by signal 6: Aborted

Am I out of luck here? Do I need to somehow move these tables back to the
original cluster? Or is there another way?

Appreciate your time looking at this.

--
*Mark Steben*
Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Arjun Ranade 2017-11-14 20:00:03 Re: PG10 - Out of shared memory / invalid memory alloc request size
Previous Message Alvaro Aguayo Garcia-Rada 2017-11-14 19:53:06 Re: PG10 - Out of shared memory / invalid memory alloc request size