Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Should `pg_upgrade --check` check relation filenodesare present? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] Should `pg_upgrade --check` check relation filenodesare present?
Date
Msg-id b65284a8-e218-9625-b1d7-75c86137b8f2@2ndquadrant.com
Whole thread Raw
In response to [HACKERS] Should `pg_upgrade --check` check relation filenodes are present?  (Craig de Stigter <craig.destigter@koordinates.com>)
List pgsql-hackers
Tree view 
On 1/31/17 4:57 PM, Craig de Stigter wrote:
> However, this problem was not caught by the `--check` command. I'm
> looking at the source code and it appears that pg_upgrade does not
> attempt to verify relation filenodes actually exist before proceeding,
> whether using --check or not.

The purpose of --check is to see if there is anything in your database
that pg_upgrade cannot upgrade.  Its purpose is not to detect general
damage in a database.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] [Bug fix] PQsendQuery occurs error whentarget_session_attrs is set to read-write
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Cannot shutdown subscriber after DROP SUBSCRIPTION