Re: pg_upgrade failed for 9.0 to 9.2

On Jan 13, 2013, at 1:36 PM, AI Rumman <rummandba(at)gmail(dot)com> wrote:

> CREATE VIEW stats_slowest_queries AS
> SELECT pg_stat_activity.procpid, (('now'::text)::timestamp(6) with time
> zone - pg_stat_activity.query_start) AS execution_time,
> pg_stat_activity.current_query FROM pg_stat_activity WHERE
> (pg_stat_activity.current_query !~~ '<IDLE%'::text) ORDER BY
> (('now'::text)::timestamp(6) with time zone - pg_stat_activity.query_start)
> DESC;
> psql:pg_upgrade_dump_db.sql:498897: ERROR: column pg_stat_activity.procpid
> does not exist
> LINE 2: SELECT pg_stat_activity.procpid, (('now'::text)::timesta...
> ^
> It failed.

Reason is: From postgreSQL 9.2 onwards, pg_stat_activity.procpid is renamed as pg_stat_activity.pid.
http://www.postgresql.org/docs/9.2/interactive/release-9-2.html

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog:http://vibhork.blogspot.com