pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: A Farkas <frks@tutanota.com>
To: pgsql-admin@lists.postgresql.org
Subject: Backup restore question "could not locate required checkpoint record"
Date: Fri, 8 Mar 2019 10:31:35 +0100 (CET)
Message-ID: <L_Ra1J3--3-1@tutanota.com> (raw)


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.

view thread (3+ messages)  latest in thread

Message-ID: <L_Ra1J3--3-1@tutanota.com>
Permalink:  ../L_Ra1J3--3-1@tutanota.com/
Also on:    postgresql.org/message-id/L_Ra1J3--3-1@tutanota.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: frks@tutanota.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Backup restore question "could not locate required checkpoint record"
  In-Reply-To: <L_Ra1J3--3-1@tutanota.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox