Re: [GENERAL] pg_upgrade failed for 9.0 to 9.2

2013-01-13 Thread Bruce Momjian
On Sun, Jan 13, 2013 at 02:17:34PM -0500, Vibhor Kumar wrote: > > On Jan 13, 2013, at 1:36 PM, AI Rumman 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, >

Re: [GENERAL] pg_upgrade failed for 9.0 to 9.2

2013-01-13 Thread Vibhor Kumar
On Jan 13, 2013, at 1:36 PM, AI Rumman 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_acti

[GENERAL] pg_upgrade failed for 9.0 to 9.2

2013-01-13 Thread AI Rumman
Hi, When I was upgrading database from 9.0 to 9.2 using pg_upgrade, I got the error: 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