pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Error while upgrading from 9.5 to 10
Date: Wed, 21 Nov 2018 12:00:23 +0200
Message-ID: <8cf77b4d-64af-a986-1819-767e71554b0a@matrix.gatewaynet.com> (raw)
In-Reply-To: <CABzZDZB36bgzNYorjZaKwhU6RkJmOH6dgjABeRJD4WFNRG_Qug@mail.gmail.com>
References: <CABzZDZB36bgzNYorjZaKwhU6RkJmOH6dgjABeRJD4WFNRG_Qug@mail.gmail.com>

On 21/11/18 6:59 π.μ., Srinivas Reddy wrote:
> Hi
>
> Trying to upgrade major vesion from 9.5 to 10 using pg_ugrade, but getting below error,
>
> pg_restore: connecting to database for restore
> pg_restore: creating pg_largeobject "pg_largeobject"
> pg_restore: creating pg_largeobject_metadata "pg_largeobject_metadata"
> pg_restore: creating COMMENT "DATABASE "postgres""
> pg_restore: creating SCHEMA "postgres_exporter"
> pg_restore: creating SCHEMA "public"
> pg_restore: creating COMMENT "SCHEMA "public""
> pg_restore: creating VIEW "postgres_exporter.pg_stat_activity"

What is this schema : postgres_exporter ?
I'd suggest taking a back up of the objects in this schema, den DROP everything in there and retry.

> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 182; 1259 17640 VIEW pg_stat_activity postgres
> pg_restore: [archiver (db)] could not execute query: ERROR: column pg_stat_activity.waiting does not exist
> LINE 27:     "pg_stat_activity"."waiting",
>              ^
>     Command was:
> -- For binary upgrade, must preserve pg_type oid
> SELECT pg_catalog.binary_upgrade_set_next_pg_type_oid('17642'::pg_catalog.oid);
>
>
> -- For binary upgrade, must preserve pg_type array oid
> SELECT pg_catalog.binary_upgrade_set_next_array_pg_type_oid('17641'::pg_catalog.oid);
>
>
> -- For binary upgrade, must preserve pg_class oids
> SELECT pg_catalog.binary_upgrade_set_next_heap_pg_class_oid('17640'::pg_catalog.oid);
>
> CREATE VIEW "postgres_exporter"."pg_stat_activity" AS
>  SELECT "pg_stat_activity"."datid",
>     "pg_stat_activity"."datname",
>     "pg_stat_activity"."pid",
>     "pg_stat_activity"."usesysid",
>     "pg_stat_activity"."usename",
>     "pg_stat_activity"."application_name",
>     "pg_stat_activity"."client_addr",
>     "pg_stat_activity"."client_hostname",
>     "pg_stat_activity"."client_port",
>     "pg_stat_activity"."backend_start",
>     "pg_stat_activity"."xact_start",
>     "pg_stat_activity"."query_start",
>     "pg_stat_activity"."state_change",
>     "pg_stat_activity"."waiting",
>     "pg_stat_activity"."state",
>     "pg_stat_activity"."backend_xid",
>     "pg_stat_activity"."backend_xmin",
>     "pg_stat_activity"."query"
>    FROM "pg_stat_activity";
>
> how to resolve this issue?
>
> -- 
> _THANKS AND REGARDS_
> /SRINIVAS REDDY G A/


-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

view thread (3+ messages)  latest in thread

Message-ID: <8cf77b4d-64af-a986-1819-767e71554b0a@matrix.gatewaynet.com>
Permalink:  ../8cf77b4d-64af-a986-1819-767e71554b0a@matrix.gatewaynet.com/
Also on:    postgresql.org/message-id/8cf77b4d-64af-a986-1819-767e71554b0a@matrix.gatewaynet.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: achill@matrix.gatewaynet.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Error while upgrading from 9.5 to 10
  In-Reply-To: <8cf77b4d-64af-a986-1819-767e71554b0a@matrix.gatewaynet.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