Postgres Pro
Downloads
Home   >   mailing lists

Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success. - Mailing list pgsql-general

From Ron Johnson
Subject Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
Date
Msg-id CANzqJaBXjYHdiecfpm0u3Fho857FwWsHTB51+K6tLbvA0wn3CA@mail.gmail.com
Whole thread Raw
In response to Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.  (Sri Mrudula Attili <sri@ebi.ac.uk>)
List pgsql-general
Tree view
On Wed, Nov 29, 2023 at 12:20 PM Sri Mrudula Attili <sri@ebi.ac.uk> wrote:
Hello Laurenz,


  Thanks for your response.


This error we are seeing on a delphix Virtual database that was
refreshed using the snapshot of production standalone database.


It keeps the database in pg_start_backup and to take the snapshot.
 
Isn't pg_basebackup the canonical method for taking a snapshot?  (PgBackRest, too, if you want more speed.)


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
Next
From: "Dirschel, Steve"
Date:
Subject: Query runtime differences- trying to understand why.