Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1h2Bqz-0003cJ-E9
	for pgsql-admin@arkaria.postgresql.org; Fri, 08 Mar 2019 09:31:46 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1h2Bqx-00042l-Nc
	for pgsql-admin@arkaria.postgresql.org; Fri, 08 Mar 2019 09:31:43 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <frks@tutanota.com>)
	id 1h2Bqx-00041n-1L
	for pgsql-admin@lists.postgresql.org; Fri, 08 Mar 2019 09:31:43 +0000
Received: from w1.tutanota.de ([81.3.6.162])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <frks@tutanota.com>)
	id 1h2Bqt-0006ND-47
	for pgsql-admin@lists.postgresql.org; Fri, 08 Mar 2019 09:31:41 +0000
Received: from w2.tutanota.de (unknown [192.168.1.163])
	by w1.tutanota.de (Postfix) with ESMTP id 37E50FA02FE
	for <pgsql-admin@lists.postgresql.org>; Fri,  8 Mar 2019 09:31:36 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=tutanota.com;
	s=20161216; t=1552037496;
	bh=y+5dD3ZPDf1q7jz3NcWkWN7+ck4uM51iu6h6gJC7RVk=;
	h=Date:From:To:Subject:From;
	b=sV66++9s7/jgva/yWY/spxUqdY/AT7+Cz0oZIb6HPOnnfPmmRrzw7fCxOmyFkRNcB
	 tZfvXEhqMOxCDTFuZ4xrcul8Gk71eMEuxnCYsbuIq553Jc826YgpZeZRnv5LYwBEDb
	 ooG+EWS79CdlNuX9nfhAA2dv+VNXgAcj1sP9kTSHtx83MGZQ0m5mFHzqFbFPXJcxSe
	 2C9DF+JJ5uqx85W4PWhcMDHfBWWvPJgwE/QGulaf8NmUJZQ/nN8ditWqgZrYNa/AkR
	 SPkI7uI3tVQqWcGB/wmNOj4vq16IoDYclH+A02npPWXYigA2q8gu/3hMm3MmJb52RW
	 l4l4VfdMR6YTw==
Date: Fri, 8 Mar 2019 10:31:35 +0100 (CET)
From: A Farkas <frks@tutanota.com>
To: <pgsql-admin@lists.postgresql.org>
Message-ID: <L_Ra1J3--3-1@tutanota.com>
Subject: Backup restore question "could not locate required checkpoint
 record"
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_26767_995408550.1552037496222"
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

------=_Part_26767_995408550.1552037496222
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable


On a new apt-get install of postgresql 11, I performed the following:
backup (pg_start_backup ('b1'), rsync, pg_stop_backup)
CREATE DATABASE
CREATE TABLE
INSERT INTO TABLE
DROP TABLE
backup (pg_start_backup ('b1'), rsync, pg_stop_backup)

The point is to restore point in time, before DROP.