Postgres Pro
Downloads
Home   >   mailing lists

Re: Querying an index's btree version - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Querying an index's btree version
Date
Msg-id 2d743ef574d27d153f693fca41ec102689b66679.camel@cybertec.at
Whole thread Raw
In response to Re: Querying an index's btree version  (Darren Lafreniere <dlafreniere@onezero.com>)
List pgsql-general
Tree view 
On Wed, 2020-03-11 at 17:12 -0400, Darren Lafreniere wrote:
> Separate but related follow-up question: when you restore a DB from a backup, does the restored index use the old
formator the latest one?
 

If you restore a pg_dump, you will have the latest version.

If you restore a file system backup, you will have what you had before.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

pgsql-general by date:

Previous
From: Kevin Brannen
Date:
Subject: pg_restore restores out of order
Next
From: Adrian Klaver
Date:
Subject: Re: pg_restore restores out of order