Re: [HACKERS] Should `pg_upgrade --check` check relation filenodes are present?

2017-02-25 Thread Bruce Momjian
On Wed, Feb 1, 2017 at 10:57:01AM +1300, Craig de Stigter wrote: > Hi list > > We attempted to pg_upgrade a database on a replication slave, and got the > error: > > > error while creating link for relation "." ("/var/ > lib/postgresql-ext/PG_9.2_201204301/19171/141610397" to

Re: [HACKERS] Should `pg_upgrade --check` check relation filenodes are present?

2017-02-01 Thread Peter Eisentraut
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

Re: [HACKERS] Should `pg_upgrade --check` check relation filenodes are present?

2017-01-31 Thread Tom Lane
Craig de Stigter writes: > We attempted to pg_upgrade a database on a replication slave, and got the > error: > error while creating link for relation "." > ("/var/lib/postgresql-ext/PG_9.2_201204301/19171/141610397" to >

[HACKERS] Should `pg_upgrade --check` check relation filenodes are present?

2017-01-31 Thread Craig de Stigter
Hi list We attempted to pg_upgrade a database on a replication slave, and got the error: error while creating link for relation "." >> ("/var/lib/postgresql-ext/PG_9.2_201204301/19171/141610397" to >> "/var/lib/postgresql-ext/PG_9.5_201510051/16401/9911696"): No such file or >> directory > > >